S scott Mar 25, 2010 #1 what formula will allow me to convert feet and inches to meters. current format of cell is 5’05.00â€
what formula will allow me to convert feet and inches to meters. current format of cell is 5’05.00â€
M macropod Mar 25, 2010 #2 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
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
S scott Mar 25, 2010 #3 thank you very much -- 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 . Click to expand...
thank you very much -- 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 . Click to expand...
