| 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.? |
|
#2
|
|||
|
|||
|
On 29 Jun 2005 08:00:48 -0700, "geoff" wrote:
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? Format/Cells/Number Custom Type: #;"(#)";- Is there any reference which explains the format specification in the custom list of options.? type "Number Format Codes" into HELP --ron |
|
#3
|
|||
|
|||
|
Many thanks,
Geoff |
| Reply |
| 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) | |||
Linear Mode
