S
scott
what formula will allow me to convert feet and inches to meters. current
format of cell is 5’05.00â€
format of cell is 5’05.00â€
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
David Biddulph
=CONVERT(LEFT(A1,FIND("'",A1)-1)*12+MID(A1,FIND("'",A1)+1,LEN(A1)-FIND("'",A1)-1),"in","m")
M
macropod
Hi Scott,
Assuming the actual number is 505 and it's just a custom format you're using to display it as 5’05.00â€, you could use a formula
like:
=(INT(A1/100)*12+MOD(A1,100))*0.0254
Assuming the actual number is 505 and it's just a custom format you're using to display it as 5’05.00â€, you could use a formula
like:
=(INT(A1/100)*12+MOD(A1,100))*0.0254
S
scott
thank you very much
--
Thanks in advance
--
Thanks in advance
David Biddulph said:=CONVERT(LEFT(A1,FIND("'",A1)-1)*12+MID(A1,FIND("'",A1)+1,LEN(A1)-FIND("'",A1)-1),"in","m")
--
David Biddulph
.
D
David Biddulph
You're welcome. Glad it did the job.