Re: display negative numbers as either a dash or a zero

Giganews Newsgroups
Subject: Re: display negative numbers as either a dash or a zero
Posted by:  Andy B (andy@removethisbit.dawsons.co.uk)
Date: Wed, 15 Oct 2003

mmc

Right-click on the cell/range and select Format cells. From the number tab
select Custom and in the Type: box put
#,##0;-

Andy.

"mmc helpdesk" <anonymo…@discussions.microsoft.com> wrote in message
news:103901c39331$f052e1b0$a40128…@phx.gbl...
> Does anyone know how to display a negative number in
> Excel 2000 as either a dash or a zero?  Thanks!

Replies

None

In response to

display negative numbers as either a dash or a zero posted by mmc helpdesk on Wed, 15 Oct 2003