# Excel - FORMULA FOR CELSIUS TO FAHRENHEIT

```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
`This worked.  Thanks.`