relatively short text in cell causing hash marks

  • Thread starter Thread starter jspollock
  • Start date Start date
J

jspollock

I only have 250 or so characters in the cell and it is only displaying
hash marks. I have the cell set to text and when I remove one line it
shows up normally. I don't know how to change it, but the specs show
that over 1000 characters should show up just fine in the cell. Any
suggestions?

Sounds simple. I appreciate any help.

Stephen
 
Hi
have you tried to make the cell larger (wider / higher). also try to
enable word wrap
 
In addition, most times Formatting to General(not Text) will drop the ##### if
word-wrap and wider/higher doesn't do it for you.

Gord Dibben Excel MVP
 
Back
Top