View Single Post
  #4   Report Post  
Fred Smith
 
Posts: n/a
Default

### has nothing to do with negative numbers. It's what Excel displays when
the column isn't wide enough to show the number. Widen the column
sufficiently. The easiest way to get the proper width is to double click the
right edge of the column header. (eg, if your number is in Column D,
position the cursor on the vertical line between D and E, wait until Excel
turns the cursor into a double headed arrow, then double click).

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"molly" wrote in message
...
using =SUM(G2:I2) it comes up at ## but there it shouldn't be a negative
value??