View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kleivakat kleivakat is offline
external usenet poster
 
Posts: 29
Default Format Cells - Architectural Dimensions

Can I format cells to use architectural dimensions so that I can sort and
average dimensions? I need to be able to enter and work with numbers that
look like:

2'-6"
3'-8"

I'd rather not convert to inches if I don't have to. If I did that, I would
want a macro to figure out the math (i.e., 3'-8" - 44") since I have a lot of
data to deal with. Also, the nubmers are given to me in dimensions, and I
don't want to convert in my head as I enter data.

Thanks for any info.

KK