using =SUM(G2:I2) it comes up at ## but there it shouldn't be a negative
value??
using =SUM(G2:I2) it comes up at ## but there it shouldn't be a negative
value??
Is the column wide enough to display the answer.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"molly" <[email protected]> wrote in message
news:[email protected]...
> using =SUM(G2:I2) it comes up at ## but there it shouldn't be a negative
> value??
--
HTH
RP
(remove nothere from the email address if mailing direct)
"molly" <[email protected]> wrote in message
news:[email protected]...
> using =SUM(G2:I2) it comes up at ## but there it shouldn't be a negative
> value??
### 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" <[email protected]> wrote in message
news:[email protected]...
> using =SUM(G2:I2) it comes up at ## but there it shouldn't be a negative
> value??
I've seen ###'s when I have negative numbers in a cell that's formatted as time
or date (and I'm not using the 1904 base date).
And I've seen ###'s when the value in the cell is numeric, but the format is
Number (say) and it won't fit. (Formatting as General will change the display
to Scientific--until the column is just too skinny to show even that.)
And I've seen ###'s when I had the long text in the cell and the cell was
formatted as Text. (Long text = 256 to 1024 characters).
molly wrote:
>
> using =SUM(G2:I2) it comes up at ## but there it shouldn't be a negative
> value??
--
Dave Peterson
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" <[email protected]>
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).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks