answer:I am not aware of an off-the-shelf solution. Hopefully someone has an easier way, but here’s how I approach the question: 1) The INT function will give you the whole number (41) =INT(41.8001) 2) MOD gives the remainder (0.8001) =MOD(41.8001,1) 3) INT and MOD will give you inches (9) =INT(MOD(41.8001,1) * 12) And I’ve never done fractions, but here’s a page about it: www.mrexcel.com/articles/display-fractions-in-excel.php Sorry to give an incomplete answer, but that’s all I have time for this morning.