Why not use 7 4/12
Just use custom format: # ??/12
Long live the SI system!
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"donhoe" wrote in message
...
how do I create an architectural number format?

as in 7'-2", 16'-0", 1'-0 1/2"

and be able to add them up. right now they all show up as text.