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

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