View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jose Jose is offline
external usenet poster
 
Posts: 35
Default Help with Formatting cells

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!