Why does my cell content display as '############'?

[Mark]

when typing text into a cell, the cell will display '#######' instead of the
actual text I've typed. re-sizing the row/column does not help.

 

[John C]

It would help if we knew what you were typing (formula or not formula), and
how you have the cell formatted.

 

[Dave Peterson]

Try formatting the cell as General.

when typing text into a cell, the cell will display '#######' instead of the
actual text I've typed. re-sizing the row/column does not help.

 

[RagDyeR]

You're probably experiencing the "text bug"!


Format the cell(s) to "General".


There seems to be a quirk (bug), where in a Text formatted cell of more then
approximately 256 characters, you'll get the ###'s.


Stranger yet, if you keep typing, the true text *returns* when the character
count exceeds 1024.


General format should work for the "in-between" character count.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================



when typing text into a cell, the cell will display '#######' instead of the
actual text I've typed. re-sizing the row/column does not help.

 

[Richard O. Neville]

Try widening the column to accommodate the cell contents.