Try formatting the cell as General.

When you use a number format of Text, excel will have trouble with strings
between 255 and 1024 characters.

Andre wrote:

Long text in a cell shows up as a long string of ###. When I double click the
cell it displays the text but after pointing to another cell the text
disappears and changes to ####.
Any idea where the problem is?
--
Andre

--

Dave Peterson