display negative numbers as either a dash or a zero

  • Thread starter Thread starter mmc helpdesk
  • Start date Start date
M

mmc helpdesk

Does anyone know how to display a negative number in
Excel 2000 as either a dash or a zero? Thanks!
 
Click on this cell, right click and select format cells in
the menu that'll pop up. In the number tab, select
accounting. that should do it.
 
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.
 
-----Original Message-----
Does anyone know how to display a negative number in
Excel 2000 as either a dash or a zero? Thanks!
.
Yes, use an if function. This only works if the nuber
Click to expand...
you are trying to display has been worked out buy a
fornula or calculation in that cell, example:

instead of =3-B2

- B2 is just a cell reference

use =IF(3-B2>0,"-",3-B2)

This would work out a display the answer to the
calculation if it was zero or greater and display whatever
you put between the speech marks if the answer was less
than zero).

if your trying to do this in a cell that you want to type
a number in and show a zero or dash if the number typed
(rather than calculated as in the above example) is less
than zero then you've got a problem.

You either hhave to have one cell to type in and another
to put the if function into

Or you can validate what numbers can be typed into a cell.

if this didn't make sense or you need more help just send
me an email

Regards

Jim
 
Back
Top