How to Convert Fahrenheit to Celsius in Microsoft Excel

Most thermometers show Celsius on one side and Fahrenheit on the other.
••• Thinkstock/Stockbyte/Getty Images

The Fahrenheit scale is a measure of temperature primarily used in the United States, while the rest of the world uses the Celsius scale. There may be times when it is necessary to take a Fahrenheit temperature and convert it to Celsuis. To complete this by hand you'd use the formula (F - 32) (5/9) = C. Since this formula is not always simple to use and a calculator might not be available, another tool can help. Microsoft Excel has a simple way to complete this calculation using the Convert function.

Using the Convert Function

To use Microsoft Excel's Convert feature to change Fahrenheit to Celsius, follow these steps:

  • In a blank Excel document, enter the temperature in Fahrenheit in the first cell of the first column.
  • In the cell to the right of the Fahrenheit temperature, enter the formula =CONVERT(A1,"F","C").
  • Click the Enter key on your keyboard to complete the conversion.

For example, if starting with the temperature 89 degrees Fahrenheit: Type 89 into the first cell. Type =CONVERT(A1,"F","C") in the cell beside that one. * Click Enter.

The converted temperature will show 31.67 degrees Celsius.

This Convert function makes Excel a handy tool for quickly converting between temperature scales.

Related Articles

How to Convert 220 Celsius to Fahrenheit
How to Convert Kelvin to Atmosphere
How to Read a Celsius Thermometer
How to Use the TI-84 Plus Calculator to Convert Sine,...
What Is the Degree Difference Between Celsius vs. Fahrenheit?
How to Change a Digital Thermometer to Read Fahrenheit
How to Convert Celsius to Fahrenheit for 5th Grade
The Four Types of Temperature Scales
How to Convert Celsius to Kelvin
How to Convert Fahrenheit to Kelvin
How to Convert CM to Inches in Excel
How to Convert 400 Fahrenheit to Celsius
How to Calculate Angles Without a Protractor
How to Calculate the Change in Temperature
How to Convert 180 Degrees Metric to Fahrenheit
How to Calculate Thermocouple Sensitivity
How to Read Protractors
How to Convert RPM to MPH With a Calculator
How to Convert KBTU to BTU
How Do I Check Millivolts on a Thermocouple?