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!! #,###, |
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!! #,###, |
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!! #,###, |
All times are GMT +1. The time now is 09:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com