Text does not appear in cell, instead "#########..."

[Carissa]

Typing text into cell, but when complete and click off cell, text does not
appear in cell. Instead a series of pound signs (#) appear in cell. Text
appears in other cells, but this particular cell only shows pound signs when
the cell is not selected.

Please advise! Thank you.

[VBA Noob]

Have you tried to auto fit the cell

VBA Noob

[Don Guillett]

try widening the column

--
Don Guillett
SalesAid Software
[email protected]
"Carissa" <[email protected]> wrote in message
news:[email protected]...
> Typing text into cell, but when complete and click off cell, text does not
> appear in cell. Instead a series of pound signs (#) appear in cell. Text
> appears in other cells, but this particular cell only shows pound signs
> when
> the cell is not selected.
>
> Please advise! Thank you.

[Gary''s Student]

If re-sizing the cell oes not fix the problem, then format the cell as
General rathr than Text.
--
Gary's Student


"Carissa" wrote:

> Typing text into cell, but when complete and click off cell, text does not
> appear in cell. Instead a series of pound signs (#) appear in cell. Text
> appears in other cells, but this particular cell only shows pound signs when
> the cell is not selected.
>
> Please advise! Thank you.

[Carissa]

Thank you, changing the format to general fix the problem.

"Gary''s Student" wrote:

> If re-sizing the cell oes not fix the problem, then format the cell as
> General rathr than Text.
> --
> Gary's Student
>
>
> "Carissa" wrote:
>
> > Typing text into cell, but when complete and click off cell, text does not
> > appear in cell. Instead a series of pound signs (#) appear in cell. Text
> > appears in other cells, but this particular cell only shows pound signs when
> > the cell is not selected.
> >
> > Please advise! Thank you.

[Gord Dibben]

Carissa

Excel has a problem with cells that contain text with length between 255 and
1024 characters ans shows the ### signs.

Format the cell(s) to General and should go away.


Gord Dibben MS Excel MVP

On Tue, 1 Aug 2006 12:14:02 -0700, Carissa <[email protected]>
wrote:

>Typing text into cell, but when complete and click off cell, text does not
>appear in cell. Instead a series of pound signs (#) appear in cell. Text
>appears in other cells, but this particular cell only shows pound signs when
>the cell is not selected.
>
>Please advise! Thank you.