View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sloth Sloth is offline
external usenet poster
 
Posts: 252
Default How do I convert 4'6" into decimals?

for decimal feet use

=LEFT(A1,FIND("'",A1)-1)+MID(A1,FIND("'",A1)+1,LEN(A1)-1-FIND("'",A1))/12

and for inches use

=LEFT(A1,FIND("'",A1)-1)*12+MID(A1,FIND("'",A1)+1,LEN(A1)-1-FIND("'",A1))

"Curious" wrote:

I am new and this is driving me crazy. I am doing a worksheet where I want
to convert feet and inches into decimal. Does that even make sense?

Any help would be greatly appreciated!