Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating only non-empty cells... | Excel Worksheet Functions | |||
Why will my cells not format? | New Users to Excel | |||
Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
format cells dialog box does not come up | Excel Discussion (Misc queries) | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) |