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

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

Jon Peltier

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/
_______
 

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