Accounting format returns a - for zero other cells show 0.0 Why?


T

The Bookeeper

Cell format set to accounting returns a - for zero. The sample box also shows
-.
On other cells with accounting format 0.00 is returned and the sample box
shows 0.00. How can the sample be changed to give me a consistent format?

Many thanks
 
Ad

Advertisements

A

Alojz

Maybe ur cell which shows 0.00 is not zero, but value close to zero having
some decimal value at 3th or further decimal place, e.g. 0.001, 0.00000099 or
so. Did you try to round on two decimal places first?
 
F

Fred Smith

A value of 0.004 will display as 0.00 in accounting format. It means your
answer is close to zero, but it's not zero. If you want this displayed as -,
the round the result, as in:

=round(yourformula,2)

Regards,
Fred.
 
T

The Bookeeper

Alojz said:
Maybe ur cell which shows 0.00 is not zero, but value close to zero having
some decimal value at 3th or further decimal place, e.g. 0.001, 0.00000099 or
so. Did you try to round on two decimal places first?

"The Bookeeper" wrote:

Thanks. Sorted
 
T

The Bookeeper

many thanks, formula worked gr8

Fred Smith said:
A value of 0.004 will display as 0.00 in accounting format. It means your
answer is close to zero, but it's not zero. If you want this displayed as -,
the round the result, as in:

=round(yourformula,2)

Regards,
Fred.
 
Ad

Advertisements

Ad

Advertisements


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

Top