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

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

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

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


.

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


.