convert meters to feet/inches

R

Ron Rosenfeld

One problem that I have while doing this is that I'd like the results to be
more precise.

I would like 12.35 meters to come out as 40' 6.25"

I'd even like to have the ' and " instead of feet/inches. Is all that a
possibility?

Thanks for help.

=INT(CONVERT(A1,"m","ft"))&"' " &
ROUND(MOD(CONVERT(A1,"m","in"),12)*4,0)/4 & """"

--ron
 
D

Dana DeLouis

I would like 12.35 meters to come out as 40' 6.25"

Not ideal, but a slightly different method might be the following.
If you can live with the leading zero on the inches...

40.' 06.22 ''

=TEXT(DOLLARFR(CONVERT(A1,"m", "ft"),12),"0.' 00\.00 ''")

or just use the formula, and make it a custom cell format.

= = = =
Dana DeLouis
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top