Thread: feet and inches to meters
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
macropod[_2_] macropod[_2_] is offline
external usenet poster
  
Posts: 293
Default feet and inches to meters
Hi Scott,

Assuming the actual number is 505 and it's just a custom format you're using to display it as 505.00, you could use a formula
like:
=(INT(A1/100)*12+MOD(A1,100))*0.0254

--
Cheers
macropod
[Microsoft MVP - Word]


"scott" wrote in message ...
what formula will allow me to convert feet and inches to meters. current
format of cell is 505.00
--
Thanks in advance

Reply With QuoteReply With Quote