| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
feet and inches to meters
what formula will allow me to convert feet and inches to meters. current
format of cell is 505.00 -- Thanks in advance |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
feet and inches to meters
=CONVERT(LEFT(A1,FIND("'",A1)-1)*12+MID(A1,FIND("'",A1)+1,LEN(A1)-FIND("'",A1)-1),"in","m")
-- David Biddulph "scott" wrote in message ... what formula will allow me to convert feet and inches to meters. current format of cell is 5'05.00" -- Thanks in advance |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
feet and inches to meters
thank you very much
-- Thanks in advance "David Biddulph" wrote: =CONVERT(LEFT(A1,FIND("'",A1)-1)*12+MID(A1,FIND("'",A1)+1,LEN(A1)-FIND("'",A1)-1),"in","m") -- David Biddulph "scott" wrote in message ... what formula will allow me to convert feet and inches to meters. current format of cell is 5'05.00" -- Thanks in advance . |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
feet and inches to meters
You're welcome. Glad it did the job.
-- David Biddulph "scott" wrote in message ... thank you very much -- Thanks in advance "David Biddulph" wrote: =CONVERT(LEFT(A1,FIND("'",A1)-1)*12+MID(A1,FIND("'",A1)+1,LEN(A1)-FIND("'",A1)-1),"in","m") -- David Biddulph "scott" wrote in message ... what formula will allow me to convert feet and inches to meters. current format of cell is 5'05.00" -- Thanks in advance . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert meters to feet/inches | Excel Worksheet Functions | |||
| Convert inches & display as Feet Inches and Fractions -- BUG FREE | Excel Worksheet Functions | |||
| Converting from feet, inches and fractions to inches and decimal p | Setting up and Configuration of Excel | |||
| Feet, inches and fractions to inches and dec.....reposting for Pet | Setting up and Configuration of Excel | |||
| How do I convert Meters to Feet and Inches? | Excel Worksheet Functions | |||
Linear Mode
