Unless, of course, those negative values are dates or times which would show
the ####.


Gord Dibben Excel MVP

On Mon, 28 Mar 2005 17:11:25 -0600, "Fred Smith"
wrote:

### 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).