Excel Text Limit02 Apr 2010
Did you know that sometimes it’s better to format text in Microsoft Excel 2007 as something other than text? If you have cells containing more than 255 characters, cells formatted as “Text” are displayed as a series of # characters. It makes no difference if you set the cell to word wrap, it simply doesn’t display.
The solution is simply to leave the cell format as “General”.