Cell Character Limit odd issue

[Ody]

In a spreadsheet someone mailed me there's one cell that, after 255 characters, displays #########.

Now, I know I can display more than 255 characters in a cell but I'm not sure why this cell is behaving this way?

Any thoughts? Thanks...

 

[texasalynn]

If a cell is formatted as Text, then it will display the #### when the text is over the limit. Reformat the cell to General and the text should again show.

 

[Ody]

Sweet thanks.... it's always the simple things I overlook...