Help with Formatting cells

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

Guest

How do I format a cell to not show 0 as being negative? Could it be the
formula I'm using? This is the formula in cell L321
=F321+G321-H321-I321-J321+K321
The numbers in those cells are formatted and entered to show only 2 places
after the decimal. Yet I sometimes end up with results like this
..00000000000022737367544 . HELP!
 
Do you know why this only happens with some of the cells and not all of them.
I have this formula copied into approximately 350 cells and about 70 of them
give me negative zero's (0.00), when the answer should just be 0.00 . Why
does this happen with only some and not all of the cells?
 
It sounds like the eternal problem of being unable to give an exact
representation of most decimal numbers in fixed point binary.
You've seen the difficulty of giving an exact representation of 1/3 in fixed
point decimal, and you will find the same difficulty in representing 1/10 in
fixed point binary. Sometimes the roundings will even out, sometimes they
won't.
 
You must log in or register to reply here.

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

Similar Threads

Excel VBA 1
Conditional Formatting Formula Not Working 1
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Using text and formatting sum function in formula 2
Assign format from value of another cell? 1
Excel Need Countifs Formula Help 0
formula cell format change 3
Convert number to text as displayed 3

Back
Top