Very nice Harlan.

And it returns the correct value when you get down to .304 metres, which
mine and Mr Shorty's get wrong.

Regards

Roger Govier


Harlan Grove wrote:
MrShorty wrote...

Here's one I came up with:

INT(RC[-1]*3.2808)&"ft
"&TEXT(MOD(INT(ROUND(RC[-1]*3.2808*12*8,0))/8,12),"# #/#")&"in"

Obviously the initial INT function returns the number of feet. The
inner INT(ROUND()) function rounds to the nearest 1/8 inch, the MOD
function returns the remaing inches after lopping of the number of
feet, and the TEXT function formats the output to show the number of
inches correctly.


Your feet term will be trouble when INT's argument evaluates to less
that 1/16" shy of a whole foot.

I came up with

=INT(ROUND(A28*3.2808*96,0)/96)&"' - "
&TEXT(MOD(ROUND(A28*3.2808*96,0),96)/8,"# #/#\""")