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
