Excel has always had a problem showing text when number of characters is
betweem 255 and 1024 when the cell has been formatted to TEXT

Re-format to General and the ############## wil go away.


Gord Dibben MS Excel MVP

On Thu, 20 Aug 2009 14:14:01 -0700, rflinn
wrote:

Is there a limit on the number of characters that will properly display in an
Excel 2007 cell? When I enter text with more than 259 characters, the cell
displays all #####. This happens no matter how I size the cell or whether I
have text wrap turned off or on. Is there a way to change the size limit
that will display?