| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formatting number cells
I want to show a zero as a dash and negative numbers as (#). I can do
one or the other but how can I do both? Is there any reference which explains the format specification in the custom list of options.? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cells changing from number to date | Excel Discussion (Misc queries) | |||
| How do I do conditional formatting on number formats not patterns. | Excel Discussion (Misc queries) | |||
| Conditional formatting row when cell value is an even number | Excel Worksheet Functions | |||
| Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
Threaded Mode
