Microsoft Excel Functions & Formulas

Convert from Fahrenheit to Celsius

To convert temperatures from Fahrenheit to Celsius, you can use

the formula =(Fahrenheit–32)*5/9, or you can use the calculation

described here.

4

To convert from Fahrenheit to Celsius:

1. In a worksheet, enter a few temperatures in Fahrenheit in

column A.

2. Select cells B2:B14 and type the following formula:

=(A2*1.8)+32.

3. Press <Ctrl+Enter>.

Note: You can create a user-defined format to insert the

degree sign (°). Go to the Format menu, and select Cells,

Number, Custom. In the Type box, select General and press

OK. Select a cell, hold down the <Alt> key, type 0176 on the

numeric keypad, then release <Alt> and type either ...