Excel text displays incorrectly

[Zach]

I am typing text into a cell in Excel (Office XP). I formatted the cells for
text, and to wrap the text. Text I typed before I formatted the cells (range
of cells), are displaying properly.

But text I have typed after formatting is showing in the cells as #######.
If I double click on a cell, the text appears. Exit the cell, and the
display reverts to ####. I have tried sizing the cells more than large
enough to contain the text, and that is not working.

Anybody have an idea how to fix this?

 

[Suzanne S. Barnhill]

In my experience that display means that the number is too long to be
displayed in the current column width.

 

[Zach]

You are correct, changing to general format solved the problem. I had the
cell formatted for text, which I guess is misleading, because it didn't work
with text.

Thanks.