Formatting Cell Text

[Ben]

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

 

[Frank Kabel]

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

 

[Ben]

Thanks, Frank.

Ben

-----Original Message-----
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



.