On Thursday, 5 June 2008 01:39:03 UTC+5:30, Ann wrote:
i'm trying to convert from meters to feet and inches (not just feet
or not just inches).
so if i have 2 meters, i want the result to read 6 feet, 2 inches
for example not 6.x feet or 78 inches.
here's the formula i have, which i can't get right.
=CONVERT(2,"m","ft""in").
tia
100*100m= howmanyfeets

Perhaps...

=ROUNDDOWN(CONVERT(2,"m","ft"),0)&"ft,
"&MOD(ROUNDUP(CONVERT(2,"m","in"),2),1)*12&"in "

...which returns...

6ft, 9in

...on which Claus (our resident formula wizard) may be able to make more
efficient.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion