Extra Long Text Displays as "###########"

  • Thread starter Thread starter Fijese
  • Start date Start date
F

Fijese

I want to display extra long text in cells. So I have
already formatted the cells as text, and used the "wrap
text" feature. I also have adjusted the cells to
accomodate a lot of text, and have used a small size
narrow font.
Problem is after a certain number of characters (approx.
200), the text displays as "###################" no
matter how big the cell area for it is.
The formula bar shows all the text, but it doesn't
display.
Workaround?
 
This does not work, nor does entering on new lines within
the cell using Alt-Enter.

There is some algorithm that instructs Excel to display
text as ####### after a certain number of characters.
And I have not figured out how to turn it off.
 
Sorry it didn't work for you.

This does not work, nor does entering on new lines within
the cell using Alt-Enter.

There is some algorithm that instructs Excel to display
text as ####### after a certain number of characters.
And I have not figured out how to turn it off.
Click to expand...
 

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

Convert number to text as displayed 3
Disable automatic text wrap? 2
MS ACCESS 2013 Long Text filed filter by another tables Long text field 1
Cell resizing 12
Rotating Text 6
Link text box to a cell 1
How do you wrap larger quantites of text? 4
Text Wrapping 2

Back
Top