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

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

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

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:

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

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

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" <The wrote in message
...
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

Accounting format returns a - for zero other cells show 0.0 Wh
 

"Alojz" wrote:

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

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

Accounting format returns a - for zero other cells show 0.0 Wh
 

many thanks, formula worked gr8

"Fred Smith" wrote:

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" <The wrote in message
...
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

Accounting format returns a - for zero other cells show 0.0 Wh
 

you are welcome

"The Bookeeper" wrote:



"Alojz" wrote:

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

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