View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default FORMULA FOR CELSIUS TO FAHRENHEIT

Put an integer value in cell A2 then put this formula in B2

=CONVERT(A2,"C","F")


"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.