what does "#########" mean?
 

means that the result is too big to fit in the column width
"jacqueline_cole28" wrote in
message ...

Could mean a couple of things:

1) The column width is not wide enough to display the number in the cell.
Expand the column to see the entire number (or reformat the number to reduce
it's display width requirements.)
2) The cell contains a formula that results in a "negative time"
calculation. Negative times can't be displayed in Excel, no matter how wide
the column.

There may be others, but those are the 2 that come to mind.
--
George Nicholson

Remove 'Junk' from return address.


"jacqueline_cole28" wrote in
message ...

One more comes to mind.

When a cell is formatted as Text and character length is between 256 and 1024
you can get the ###########

Format to General and usually clears up.


Gord Dibben Excel MVP

On Mon, 13 Jun 2005 15:55:49 -0500, "George Nicholson"
wrote:

Could mean a couple of things:

1) The column width is not wide enough to display the number in the cell.
Expand the column to see the entire number (or reformat the number to reduce
it's display width requirements.)
2) The cell contains a formula that results in a "negative time"
calculation. Negative times can't be displayed in Excel, no matter how wide
the column.

There may be others, but those are the 2 that come to mind.

i don't remember ever seeing that one. Thanks

--
George Nicholson

Remove 'Junk' from return address.


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
One more comes to mind.

When a cell is formatted as Text and character length is between 256 and
1024
you can get the ###########

Format to General and usually clears up.


Gord Dibben Excel MVP

On Mon, 13 Jun 2005 15:55:49 -0500, "George Nicholson"

wrote:

Could mean a couple of things:

1) The column width is not wide enough to display the number in the cell.
Expand the column to see the entire number (or reformat the number to
reduce
it's display width requirements.)
2) The cell contains a formula that results in a "negative time"
calculation. Negative times can't be displayed in Excel, no matter how
wide
the column.

There may be others, but those are the 2 that come to mind.