Number format


José C.

I formated all numbers in my table as Accounting. When the value is zero (0)
the table displays a - in the cell. But some of the cells display a 0.00 or
a (0.00).

I check the formatting and they are all in Accounting. I even copy the
formatting from one cell to another, but they do not change the way excel
displays the number.

What is happening? The numbers are part of a series of formulas, but with
the exception of a few cells, they all display the zero result as -, which is
what I want.



Mike H


These zero numbers sound like they aren't actually zero and may be very
small numbers. For example 0.001 displays as £ 0.00 when formatted as
Without seiing these formula it's difficult to offer more help


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