Convert from Fahrenheit to Celsius - Formulas In Excel - Microsoft Excel Tutorials

24.  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.

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

Watch the Video Tutorial - https://www.youtube.com/watch?v=r-bEH-bpUF4

Hope You Like This Tutorial - Give Comments