Hi Ben
this is not possible with formtas. You have to use a helper column for
this. see Chip's site for some more information:
http://www.cpearson.com/excel/fractional.htm
--
Regards
Frank Kabel
Frankfurt, Germany
Ben wrote:
Can you set a text up to display number's in foot and
inches example 12 would appear as 1' 13 would appear as
1'1' etc.?
Thanks,
Ben