Thank you for your response as another option.

"JE McGimpsey" wrote:

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


In article ,
Boyertown Casket wrote:

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.