Why are some currency values of 0 in red? I want all black.
 

I have a budget page in excel and when the balance gets to zero sometimes the
zero is red. It is confusing because only negatives should be red. How do I
get all my zero balances to be black and reds start at -.01?

Why are some currency values of 0 in red? I want all black.
 

I'll bet there's a rounding thing. The "zero" might actually be negative but
less than half a cent, like -$0.003. Therefore it shows up as a red "zero".

You could use a rounding function to make sure there are no fractional
pennies in your calculations:

=ROUND(<value,2)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"kerryd73" wrote in message
...
I have a budget page in excel and when the balance gets to zero sometimes
the
zero is red. It is confusing because only negatives should be red. How
do I
get all my zero balances to be black and reds start at -.01?