The repeated # is what Excel uses to show an entry is too large for column
width.
There is no alternative
If you told us more about the scenario maybe a workaround would be
suggested.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"PatK" wrote in message
...
I have a "text" cell that, when content gets to be too long (I assume
greater
than 255, or somesuch), all I see is a single row of pound/hash signs, ie:
################################################## ###
filling the cell. Is there a way to change the formatting so that this
does
not occur?
Thanks!
PatK