Probably the cell is formatted as Text.

Re-format to General.

Excel has problems with Text-formatted cells when character count is 255 to 1024

BTW.....unless the merged cells are just for appearance, I would dump them.

They will cause you no end of problems with sorting, copying, pasting,
autofitting and a host of others I can't remember right now.


Gord Dibben MS Excel MVP


On Wed, 28 Feb 2007 12:05:05 -0800, ExcelRon
wrote:

In my excel spreadsheet there is are merged cells that I input text into each
month. Some seem to work fine, however others display a single line of
###########
instead of my actual text.

Why does this happen, and how can I fix it?

Thanks.