But if 1.9878 is in feet, then format the sell with custom format # ??/12 to
see 2
And 15.56 shows as 15 7/12


If 1.9878 is metres and is in A1 then =A1/0.038 with the same custom format
show 52 4/12

In all cases, the values are numeric and you can do math on them.

best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"sjl" wrote in message
...
if i have a value such as 1.9878 and want to show it to the nearest feet
and
inches how would i do it?