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

Wrapping and Anchors 0
Word macro that can call cells out of Excel for a find and replace 0
Move Chart with Text 0
Cell data entering slow! 0
Finding the right style field in VBA 0
Problem with MS Word paragraph and character styles: format getting messed up 2
Merging from an Excel file with graphics 1
Creating Labels Over 3-Up Image 2

Top