If it's text, try changing the format of that cell to General.

Long text (255 characters to 1024 characters) in cells formatted as Text will
show as ####'s.



Betsy wrote:
>
> I have large blocks of text in some of my cells and they show up as
> ########## instead of the text I put there. If I click on the cell I see my
> text above in the text edit box, but not on the spreadsheet.

--

Dave Peterson