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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
If re-sizing the cell oes not fix the problem, then format the cell as
General rathr than Text.
 
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
 
Back
Top