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

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 ####.
 
E

EricG

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
 
J

Jim Thomlinson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Missing text 1
why do I get a series of pound signs in a cell? 7
Wrapping text with line breaks problem 1
Getting word wrap to work in a merged cell 1
Cells ignore Wrap Text formatting! 2
Cannot save text wrapping in cells-must do individually 1
Wrap text in merged cells VBA 2
Info cut off in a cell 3

Top