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 Kelvin to Atmosphere
How to Read a Celsius Thermometer
How to Change a Digital Thermometer to Read Fahrenheit
What Is the Degree Difference Between Celsius vs. Fahrenheit?
How to Use the TI-84 Plus Calculator to Convert Sine,...
How to Convert 220 Celsius to Fahrenheit
How to Convert Celsius to Fahrenheit for 5th Grade
How to Convert CM to Inches in Excel
How to Reset a TI89
How to Convert Celsius to Kelvin
The Four Types of Temperature Scales
How to Use the Ti-30Xa Texas Instruments Calculator
How to Write Notes on a TI-84 Silver Edition Calculator
How to Convert Celsius to Fahrenheit
Instructions for a Casio MS 80
How to Calculate Thermocouple Sensitivity
How to Convert 400 Fahrenheit to Celsius
How to Decrease Digits in Excel
How to Graph a Distribution for a T-Test
How to Find Slope on the TI Nspire