Hi, try
=MROUND(CONVERT(F11,"m","ft"),1/32)

"Tereena" wrote:

Microsoft Excell 2007 - I am trying to convert a number to feet and inches.
As far as I can tell it will only show feet or inches but not both such as
1ft 5in.