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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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/
_______
 
Back
Top