Thanks David, that works great, however with for example 3.08 m the result is
10'0.999999999999986". Is there any way to avoid this or to have it round up
as well?
Thanks


"David Biddulph" wrote:

The answer is not in feet and inches, but in feet with decimals.
3.429m gives 11.25m, which is 11ft 3in.

You could try something like
=INT(MROUND(CONVERT(D6,"m","ft"),1/12))&"'"&MOD(MROUND(CONVERT(D6,"m","ft"),1/12),1)*12&""""The complication is to avoid getting things like 11'12"--David Biddulph"Seb" wrote in ... =CONVERT(D6,"m","ft") "bj" wrote: what formula did you use "Seb" wrote: I have converted metric into imperial using the convert function whichgives me the result I want, however Excel doesn't write it in this format11'3" but rather as 11,3 Is there any way that Excel can show the proper way (11'3") ?