I have a cell that is formatted as text with an ever growing string of text.
I have noticed that as long as there are less than about 175 to 200 characters I can see the first portion of characters that the cell width allows,
but if there is much more than that I see only ##### in the cell.
I can view all of the text just fine using the formula bar, just am a little perplexed as to why that happens.
So my question are:
(1) What is the Character limit that a cell can contain in version 2003 ?
(2) How about version 2007 ?
(3) Why the ##### after about 150 to 200 Characters?
Is that some sort of warning ?
Edit:
(4) Is there a different cell formatting I can use that will always allow me to view the first portion of the text rather than ####