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

What Is the Degree Difference Between Celsius vs. Fahrenheit?
How to Use the TI-84 Plus Calculator to Convert Sine,...
How to Read a Celsius Thermometer
What Is the Degree Difference Between Celsius vs. Fahrenheit?
How to Convert 220 Celsius to Fahrenheit
How to Convert Celsius to Fahrenheit for 5th Grade
How to Change a Digital Thermometer to Read Fahrenheit
How to Convert 23 Celsius to Fahrenheit
The Four Types of Temperature Scales
How to Convert Celsius to Kelvin
How to Convert 400 Fahrenheit to Celsius
How to Reset a TI89
How to Convert Fahrenheit to Kelvin
How to Use the Ti-30Xa Texas Instruments Calculator
RPM vs. Angular Velocity
How to Convert RPM to MPH With a Calculator
How to Convert CM to Inches in Excel
How to Read Protractors
How to Find Relative Humidity
How to Calculate Thermocouple Sensitivity

Dont Go!

We Have More Great Sciencing Articles!