How to Convert Fahrenheit to Celsius in Microsoft Excel

If you have a spreadsheet with values in Fahrenheit and need to convert them to Celsius, you don't need a calculator or an additional program; Excel can do that within the spreadsheet itself. In fact, Excel has a number of built-in functions that let you do a variety of calculations, one of which is the CONVERT function that converts values from one type of format to another -- from the common, such as temperature, to the more specialized, such as force or pressure.

Instructions

1

Open Excel and load the spreadsheet with Fahrenheit data.

2

Click an empty cell next to one of the cells with Fahrenheit values you want to convert.

3

Enter the following formula, replacing "A2" in the formula with the cell number of the value you want to convert:

=CONVERT(A2,"F","C")

4

Press "Enter" to get the corresponding value in Celsius.