View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Boyertown Casket[_2_] Boyertown Casket[_2_] is offline
external usenet poster
 
Posts: 18
Default FORMULA FOR CELSIUS TO FAHRENHEIT

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.

"egun" wrote:

To get the degree sign, etc:

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