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

[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

 

[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?

 

[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.

 

[The Bookeeper]

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

 

[The Bookeeper]

many thanks, formula worked gr8

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.

 

[Alojz]

you are welcome

Thanks. Sorted