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

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

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

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

"Cheryl" wrote:

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

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

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.
--
HTH...

Jim Thomlinson


"Cheryl" wrote:

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

One thing that I have tried when I get this problem is this: I put the NUMBER (not text) 1 in an empty cell. I copy it and go into the cell with the ###s and click Paste Special - Multiply. It gives me the text back. I wish someone could tell me why this works! I got the idea from when I want to get rid of a list of hyperlinks.