Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom format Numbers
hello,
I am using the following custom format for thousands, but I also need to show a dash ie "-" if the value is a zero, thanks for your help!! #,###, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom format Numbers
Use something like
#,###,;-#,###,;"-" Anyway, the 3rd entry (entries separated by semicolons) defines the appearance of a zero value 1. positive number 2. negative number 3. zero 4. text -- Kind regards, Niek Otten Microsoft MVP - Excel "jchick0909" wrote in message ... hello, I am using the following custom format for thousands, but I also need to show a dash ie "-" if the value is a zero, thanks for your help!! #,###, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom format Numbers
What do you want when the cell is negative? The format of a custom format
is: positive;negative;zero;text So you want something like: #,##0,;-#,##0,;- Regards, Fred "jchick0909" wrote in message ... hello, I am using the following custom format for thousands, but I also need to show a dash ie "-" if the value is a zero, thanks for your help!! #,###, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom format numbers | Excel Discussion (Misc queries) | |||
Custom Format Numbers to $$ | Excel Discussion (Misc queries) | |||
How do I keep numbers from rounding in a custom format? | New Users to Excel | |||
Custom Format for Numbers | Excel Discussion (Misc queries) | |||
How to format text and numbers as custom | Excel Discussion (Misc queries) |