Excel; shows a line of # instead of my text in a merged cell.

E

ExcelRon

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.
 
G

Gord Dibben

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
 
B

Bernard Liengme

Generally this means the cell is too narrow to display the stored entry
But merged cells have their own problems
best wishes
 
C

Chip Pearson

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)
 
E

ExcelRon

It worked! I re-formated to General and now my text is displayed. Thanks for
the tip.

I agree about merged cells, I try to avoid them whenever possible, but
there's no way around this one. Thanks again for the tip.
Ron
 
G

Gord Dibben

Chip

See my post for possible third reason when mucho text in a Text-formatted cell.


Gord
 
Top