Excel - text in cell coming out all # signs. Help.

  • Thread starter Thread starter Cheryl
  • Start date Start date
C

Cheryl

Have typed a paragraph into a cell and no matter what size I set the row to
allow the text to wrap (it's set to wrap), I get a row of ####.
 
You probably have the formatting set to "Text". Try setting it to "General".
You still might not be able to see all your text, because Excel limits the
number of characters it will display in a cell. However, when you click on
the cell, you'll see it in the formula entry area.

"Format/Cells.../Number" set to "General"

HTH,

Eric
 
Reformat the cell from Text to General. Text has a bug that cuases any text
string which is between 256 and 1024 characters in length to show up as ####.
Less than 256 or more than 1024 is fine but it does not work in the middle.
 
Back
Top