Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How do I custom format the number so that a zero is a dash (like in
accounting format) but so that I can centre the number. I want it just like the accounting format, but in Excel 2000 it doesn't let you center the number in the cell when using the accounting format. So, if I use "Custom" in Category, then what is the format code. I don't like zero when the answer is nothing. I want a dash, but want it centered. Thank you. Connie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Number formatting | Excel Discussion (Misc queries) | |||
formatting cell number based on previous cell number | Excel Discussion (Misc queries) | |||
Number formatting | Excel Discussion (Misc queries) | |||
Number formatting | Excel Discussion (Misc queries) | |||
Number Formatting | Excel Discussion (Misc queries) |