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

[Guest]

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.

 

[Don Guillett]

try widening the column

 

[Guest]

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

 

[VBA Noob]

Have you tried to auto fit the cell

VBA Noob

 

[Guest]

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

 

[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