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