How do I get a - when a 0 is typed in a cell?

[Guest]

Two cells appear to be formatted the same. (Acctg/None/2) When a 0 is typed
in one a - appears...in the other a 0 appears. I've tried format painter
with no result.

 

[Gordon]

Two cells appear to be formatted the same. (Acctg/None/2) When a 0 is typed
in one a - appears...in the other a 0 appears. I've tried format painter
with no result.

Format Cells-Custom and at the bottom there's a number of very long
gibberish-looking formats - one of those contains the "-" format for zero.

HTH

 

[Guest]

Hi,

Or you could also use the accounting format from within Format Cells ->
Number. Accounting format displays "-" for zero.

Regards,
A

 

[Guest]

Thx guys...however, neither of those worked . The format is the same in
both cells. Accounting/No symbol/0 decimals. I get a - in one cell and a 0
in the other when typing a 0. I have tried format painter to copy the
format. I want a - when I type a 0.

 

[Earl Kiosterud]

Pat,

Check the format codes (Format - Cells - Number - Custom). We'll go from
there. Are these on different sheets? If so, check Tools - Options -
View - Zero values (it's sheet-level). Not sure that any of these are your
problem, but worth looking at.

 

[Guest]

THANKS!!! It must have been sheet-level. We just upgraded. This was an old
sheet, both cells were on the same sheet. Thanks for your help!!