How to Convert Fahrenheit to Celsius in Excel

To convert Fahrenheit to Celsius in Excel, use the formula =(A1-32)*5/9, where A1 holds the Fahrenheit value — the parentheses matter, because Excel multiplies before it subtracts. For example, =(212-32)*5/9 returns 100. For a single conversion without a spreadsheet, use our free fahrenheit to celsius converter.

The Fahrenheit to Celsius Excel Formula

The formula is =(A1-32)*5/9, where A1 is the cell holding your Fahrenheit value. Type it into any empty cell and press Enter. Three anchor checks so you know it works: = (32-32)*5/9 returns 0 (freezing point), =(212-32)*5/9 returns 100 (boiling point), and =(98.6-32)*5/9 returns 37 (body temperature). If your Fahrenheit readings sit in column A starting at A2, put =(A2-32)*5/9 in B2 and you have a working converter. The whole method is two operations: subtract 32 to line up the zero points of the two scales, then multiply by 5/9 to shrink the larger Fahrenheit degrees down to Celsius size. Once the formula is right, the rest is formatting — and if you only need an occasional one-off conversion, our fahrenheit to celsius converter does the same math in one click.

Why the Parentheses Matter: Excel's Order of Operations

The single most common way people break this formula is dropping the parentheses: =A1-32*5/9. Excel follows standard order of operations, so it computes 32*5/9 first (17.78) and then subtracts that from A1 — for a 212°F input you get 194.22 instead of 100. The parentheses force Excel to subtract 32 first, then scale the result. This is worth internalizing because the same trap appears in every temperature formula: the offset (subtract 32) must happen before the scaling (multiply by 5/9). A defensive habit is to wrap the whole subtraction visibly: =((A1-32)*5)/9. It computes identically but makes the intent obvious to anyone reading your sheet six months later. Our step-by-step 20 Celsius to Fahrenheit walkthrough shows the same order-of-operations logic running in the opposite direction.

Converting a Whole Column of Temperatures at Once

Rarely is there just one temperature. If column A holds 500 Fahrenheit readings, enter =(A2-32)*5/9 in B2, then double-click the small square at the cell's bottom-right corner (the fill handle) — Excel copies the formula down the entire column, adjusting A2 to A3, A4, and so on automatically. Two refinements for real workbooks: first, if your data is in an official Excel Table (Ctrl+T), the formula propagates to new rows by itself; second, once the numbers are final, copy column B and Paste Special → Values so the sheet no longer depends on column A — handy before emailing a file to someone who might rearrange it. If the Fahrenheit column might move around, give the input range a named range like TempF and write =(TempF-32)*5/9; the formula then survives column inserts. The same copy-down pattern works for the other unit sheets in the same workbook — our centimeters to inches in Excel guide and liters to gallons in Excel guide use the identical fill-handle workflow.

Cleaning Up the Decimals: ROUND and the Degree Symbol

Raw formula output gives you 15 decimal places — 20°C from 68°F arrives as 20.000000000000004. Wrap the formula in =ROUND((A2-32)*5/9,1) for one decimal place, or use 0 for whole degrees. Do the rounding inside the cell that holds the value, not just in the display format, if those numbers feed further calculations — display-only rounding can make column totals look a penny (or a tenth of a degree) off. For presentation, select the result cells, press Ctrl+1, choose Custom, and enter 0.0"°C" as the format: Excel keeps the real number for math but displays 20.0°C. And a style note — never type the °C symbol into the formula cell itself. "20°C" typed as text turns the cell into text, silently breaking every formula downstream. Keep symbols in the format, numbers in the value.

The Reverse: Celsius to Fahrenheit in Excel

Sooner or later the sheet needs the opposite direction. The reverse formula is =A2*9/5+32 — multiply by 9/5 first, then add 32. Check it: =(20*9/5)+32 returns 68, and =(100*9/5)+32 returns 212. Notice the order flipped: scaling comes first, offset second, which is exactly the mirror of the Fahrenheit-to-Celsius order (offset first, scaling second). A clean two-way sheet uses headers — "Temp °F" in A1, "Temp °C" in B1 — with =(A2-32)*5/9 in B2 and, in a separate pair of columns, =(D2*9/5)+32 converting back. Keep one direction per column pair; mixing conversion directions in a single column is how datasets get corrupted beyond repair. For the full reverse-direction reference, see our Excel conversion collection alongside the celsius to fahrenheit converter for one-off checks.

The 5/9 Conversion Factor, Explained

The 5/9 is not a magic number — it is the ratio of the two scales' degree sizes. Between water's freezing and boiling points, Celsius spans exactly 100 degrees and Fahrenheit spans 180. So one Celsius degree equals 180/100 = 9/5 Fahrenheit degrees, and one Fahrenheit degree equals 100/180 = 5/9 of a Celsius degree. That is the entire theory: subtract 32 to align the zero points, multiply by 5/9 to resize the degrees. Two practical consequences: first, you can write the formula as =(A2-32)*0.5556, but 0.5556 is a rounded approximation — over thousands of rows the tiny error compounds, so prefer the exact fraction 5/9; second, the inverse factor 9/5 (= 1.8) explains the familiar rule that each Celsius degree is "worth" 1.8 Fahrenheit degrees, which is why weather forecasts swing so much faster in Fahrenheit. The factor is exact by international definition since 1959, not an empirical measurement.

5 Mistakes That Break the Conversion

1. Missing parentheses — =A2-32*5/9 computes A2−17.78. Always =(A2-32)*5/9. 2. Using 0.56 as the factor — close for one cell, wrong across a dataset; use the exact 5/9. 3. Text-formatted numbers — values pasted from the web often arrive as text (green triangle in the corner); the formula returns #VALUE!. Convert with Text to Columns or =VALUE(). 4. Hardcoded inputs inside the formula — =(72-32)*5/9 works once, but when the source temperature changes you must hunt through formulas; point at a cell instead. 5. Copying without locking a shared input — if every row references one settings cell, say $Z$1 for a calibration offset, the dollar signs keep the reference fixed while A2 moves to A3. Fix these five and the sheet is bulletproof. And when the workbook grows into a full unit-conversion reference, our most-used converters — the miles to kilometers converter and the celsius to fahrenheit converter — cover the other pairs in the same one-click style, or browse every free tool from the ToolNest homepage.

Fahrenheit to Celsius Quick Reference

Spot-check your sheet against these anchors: 0°F = −17.8°C, 32°F = 0°C, 68°F = 20°C, 98.6°F = 37°C, 212°F = 100°C. If any row disagrees with this table, the formula — not the table — is wrong. For temperatures beyond the everyday range, the same =(A2-32)*5/9 formula holds from absolute zero (−459.67°F) to furnace heat; the math is linear everywhere. Save the workbook as a template once it works, and the next temperature dataset converts itself in under a minute. One last pro tip for shared workbooks: add a header comment on the formula column stating the direction ("°F → °C via =(A2-32)*5/9") so a colleague never "fixes" it into the reverse formula. And if the source data arrives in mixed units — some rows Fahrenheit, some Celsius — add a helper "Unit" column and use =IF(C2="F",(A2-32)*5/9,A2) so each row converts only when needed; mixed-unit columns are the silent killer of otherwise perfect sheets.