Formating cells to add in feet and inches
 

I want to put a size, say 4 feet 5 inches in one cell and multiply this by,
say, 2 ft 3 inches in another cell. How do I format the cells to show 4'5"
and then calculate?

Thanks,

Mark

Formating cells to add in feet and inches
 

Visit www.cpearson.com where Chip has stuff on feet and inches
best wishes from the metric world
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Mark" wrote in message
...
I want to put a size, say 4 feet 5 inches in one cell and multiply this by,
say, 2 ft 3 inches in another cell. How do I format the cells to show 4'5"
and then calculate?

Thanks,

Mark