That happens for either of two reasons: (1) the column is not wide enough to
display the data, or (2) the cell is formatted for date and/or time and the
cell contains a negative value.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"ExcelRon" wrote in message
...
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.