# sign appearing in text boxes, Why?

  • Thread starter Thread starter Zaphod42b
  • Start date Start date
Z

Zaphod42b

When I have a large text box (10 lines of wrapped text) excel shows a series
of # instead of the data. This only occurs when I am outside the cell, when
inside the cell, the text displays correctly. When viewing in Print Preview,
the # appear instead of the desired text.

Why does excel do this (v2003) and how can I get it to stop?

Thanks
 
The # symbol indicates that the column is not wide enough to display the
number within the cell. Widen the column to correct.
 
It sounds like the text is not in a real textbox--just in a cell.

If that's right, try formatting the cell as General (instead of text).

If the text is long, you may find that it just "disappears" from the cell after
about 1000 characters. You can see more by adding alt-enters (to force a new
line within the cell) every 80-100 characters.
 
Thank you, Worked like a charm.

Dave Peterson said:
It sounds like the text is not in a real textbox--just in a cell.

If that's right, try formatting the cell as General (instead of text).

If the text is long, you may find that it just "disappears" from the cell after
about 1000 characters. You can see more by adding alt-enters (to force a new
line within the cell) every 80-100 characters.
Click to expand...
 
That workes, but takes me out of my page size settings. The next option
worked great, thanks for the help
 
Back
Top