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


.