Prev: in 2003 i have 0 text file conrt to 2007 number
Next: Unhide macro worksheet
From: jchick0909 on 4 Mar 2010 13:44
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!!

#,###,
From: Niek Otten on 4 Mar 2010 14:03
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" <jchick0909(a)discussions.microsoft.com> wrote in message
news:1C16848E-9408-4541-9AD0-A4FB49860FEC(a)microsoft.com...
> 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!!
>
> #,###,

From: Fred Smith on 4 Mar 2010 14:05
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" <jchick0909(a)discussions.microsoft.com> wrote in message
news:1C16848E-9408-4541-9AD0-A4FB49860FEC(a)microsoft.com...
> 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!!
>
> #,###,

 | 
Pages: 1
Prev: in 2003 i have 0 text file conrt to 2007 number
Next: Unhide macro worksheet