Maximum text length?
Don't format the cell as Text. Format it as General and I believe it will
remove the ### and wrap as you wish. I think you get this behavior when it
is formatted as text and the length exceeds 255 characters.
--
Regards,
Tom Ogilvy
"L Buchy" wrote in message
...
I have a spreadsheet with a cell formatted as text with word wrap turned
on.
It appears to have some sort of limit as ### are being displayed even if
cell is made larger in size??
Is there some kind of text length maximum in Excel?? Or can you change
this
some how?
Your help would be greatly appreciated,
Thx.
|