Zero's show as being negative numbers

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

Guest

How do I format cells in a spreadsheet to not show a zero balance as being
negative, i.e (0.00)? This does not happen in all of the cells only some?
 
It's because your value actually is negative. It's something like -0.00002,
which Excel rounds to (0.00). Change your formula to round the result to two
decimal places.
 
You asked the same question 3 hours earlier and got an answer within 6
minutes. Please don't start a new thread on the same question.
 
Back
Top