Cell format

  • Thread starter Thread starter Guest
  • Start date Start date
G

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. I want a - . Thx
 
If you truly have a zero there, it should appear as 0.00, not as 0

When examined in the formula bar, is there an apostrophe preceding the zero?
That makes it text and the numeric formatting doesn't apply. It would
likely appear to be left aligned in the cell, too.

The other thing to be aware of is that, even when in a cell formatted as
Acctg/None/2, a value greater than 0 but less than a half penny will show up
as 0.00. The only way to get it to appear as a '–' is to apply the ROUND
function to it.
 
Thanks for your response!! I think we have the answer. Tools/Options/Zero
Values.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I get a - when a 0 is typed in a cell? 5
Excel VBA 1
copy conditional formatting range 3
Using Format Painter on multiple cells 3
typing in a new cell and carrying the formatting of the previous c 2
Excel Typed text appears in wrong cell 0
Stubborn cell formatting. 1
Conditional Formatting 4

Back
Top