Hi,

Depends on what you're trying to convert. Nautical miles, yards, metres, leagues?

I suspect metres, in which case you could use:
=INT(A1/0.3048)&"ft "&ROUND((A1/0.3048-INT(A1/0.3048))*12,0)&"in"

Cheers

--
macropod
[MVP - Microsoft Word]


"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?
|
|