If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
### when the number is NOT negative?
using =SUM(G2:I2) it comes up at ## but there it shouldn't be a negative
value?? |
#2
|
|||
|
|||
-- HTH RP (remove nothere from the email address if mailing direct) "molly" wrote in message ... using =SUM(G2:I2) it comes up at ## but there it shouldn't be a negative value?? |
#3
|
|||
|
|||
Is the column wide enough to display the answer.
-- HTH RP (remove nothere from the email address if mailing direct) "molly" wrote in message ... using =SUM(G2:I2) it comes up at ## but there it shouldn't be a negative value?? |
#4
|
|||
|
|||
### 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?? |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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). |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Combo Box (1st) Populating Text Box (2nd) Field | AccessRookie | Using Forms | 1 | April 6th, 2005 11:37 PM |
incorrect sums in report using 2 tables | jkendrick75 | Setting Up & Running Reports | 22 | December 13th, 2004 02:19 PM |
Restart Autonumber | Traci | New Users | 22 | July 21st, 2004 01:10 AM |
Negative number formating | Lorenzo | Worksheet Functions | 1 | October 4th, 2003 09:22 PM |
negative number default | laura | Setting up and Configuration | 0 | September 15th, 2003 02:44 PM |