Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping a cell value constant trhoughout a list of values | Excel Worksheet Functions | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions | |||
Changing format of column from "general" to "currency" | Excel Discussion (Misc queries) |