# Excel - FORMULA FOR CELSIUS TO FAHRENHEIT

Asked By BoyertownCaske on 16-Feb-09 10:58 PM

Is there a formula available to allow me to place a Celsius temperature
(numeric equivalent) in a cell and it returns that number as a Fahrenheit
temperature?
I would like to input 2 (as in 2 o C) and have the answer be returned as:
35.6 o F
The degree symbol needs to be superscript.
Thank you.

**JLGWhi** replied on 16-Feb-09 11:17 PM

Put an integer value in cell A2 then put this formula in B2
=CONVERT(A2,"C","F")

**JE McGimpsey** replied on 16-Feb-09 11:22 PM

You could use
=CONVERT(A1,"C","F")
Format the cell using Format/Cell/Number/Custom 0.0Â°F
Or you could just use the simple formula:
= A1 * 9/5 + 32

**BoyertownCaske** replied on 17-Feb-09 09:45 AM

Thank you very much for your response.

**BoyertownCaske** replied on 17-Feb-09 09:46 AM

Thank you for your response as another option.

**egu** replied on 17-Feb-09 10:58 AM

To get the degree sign, etc:
=CONVERT(A2,"C","F")&"Â°F"

**BoyertownCaske** replied on 17-Feb-09 12:04 PM

Question: Although I followed what was given, my answer displays #NAME?
This is what I did: Cell a1 is my input and cell b1 contains the formula:
=CONVERT(a1,"C","F")&"Â°F"
b1 returns #NAME?
Will you explain what I am doing incorrectly. Do the cells need to be
formatted in any manner?
Thanks.

**JE McGimpsey** replied on 17-Feb-09 01:18 PM

CONVERT() in pre-XL07 versions is part of the Analysis Toolpak Add-in
that you can install (Tools/Add-ins...).
Alternatively, you can just use the formula I posted before:
=A1 * 9/5 + 32
which works in all versions.
In article <FA2C3B0C-EAB9-451D-9840-C7EB3B01B1F2@microsoft.com>,

**BoyertownCaske** replied on 17-Feb-09 01:26 PM