Hi All,
I need to convert millimeters into feet and inches and round down to the nearest inch. For example: 2500 mm = 8'-2". I would like the cell to acually display the ' and ".
A bit stuck on this one.
Thanks!
Jim
Bugger, I missed the round down bit. As long as the values are positive then JohnV's formula is more like it: =INT(A1/304.8)&"'-"&MOD(INT(A1/25.4);12)&""""JAR wrote:Actually 2' 11.888" I need to display as 2'-11"
Users browsing this forum: No registered users and 31 guests