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

means that the result is too big to fit in the column width
"jacqueline_cole28" <[email protected]> wrote in
message news:[email protected]...
>

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" <[email protected]> wrote in
message news:[email protected]...
>

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" <[email protected]>
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
news:[email protected]...
> 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"
> <[email protected]>
> 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.
>