Hello macropod, in some circumstances, e.g. when A1 = 1.82 the result of your
suggested formula will be "5ft 12in". To always get "6ft 0in" try

=INT(ROUND(A1/0.0254,0)/12)&"ft "&MOD(ROUND(A1/0.0254,0),12)&"in"

"macropod" wrote:

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