CONVERT FROM FAHRENHEIT TO CELSIUS USING MICROSOFT EXCEL

To convert temperatures from Fahrenheit to Celsius, you can use the formula =(Fahrenheit–32)*5/9, or you can use the calculation described here.

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-32)/1.8
3. Press <-Ctrl+Enter->.

CONVERT FROM FAHRENHEIT TO CELSIUS USING MICROSOFT EXCEL

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 “F” or “C” without the quotes.

Microsoft Excel Tutorials, Convert from fahrenheit to celsius using microsoft excel, Microsoft Excel Video Tutorials, Basic Tutorials, Advanced Excel Tutorials