Thread: convert from Fahrenheit to Centigrade
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nick Hodge Nick Hodge is offline
external usenet poster
  
Posts: 1,173
Default convert from Fahrenheit to Centigrade
Keith

If the F temp is in column A in B1 enter

=(((A1-32)/9)*5)

and copy down

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Keith Johnson" <Keith wrote in message
...
I am trying to convert several columns of fahrenheit temperatures to
centigrade but cannot get the necessary formula. Any help appreciated.

Reply With QuoteReply With Quote