| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I convert 4'6" into decimals?
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I convert 4'6" into decimals?
Because there are so many different ways that people enter ft' in" it would
be better if you could post a good representative sample of your data rather than just a single example. Biff "Curious" wrote in message ... 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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Bond prices convert to decimals | Excel Discussion (Misc queries) | |||
| Convert Lats and longs to decimals | Excel Worksheet Functions | |||
| convert lats and longs to decimals | Excel Worksheet Functions | |||
| Convert $ amount from excel to access? No decimals but 00 at end | Excel Worksheet Functions | |||
| Convert Seconds and decimals to time | Excel Discussion (Misc queries) | |||
Linear Mode
