Why is my text changing to pound signs?
 

I have been using Excel (XP) to make a text chart for several months. Some of
my text entries are rather lengthy. The past two weeks these lengthy entries
are showing up as pound signs (#########) when I click off the cell. I know
the text will fit in the cell, and the problem isn't solved by making the
cell bigger or using a little bit less text. I have the cells formatted as
"text" and "wrap to fit". I have printed the pages and the printed version
also has pound signs. I just want my text to show up!

Have you tried making the row height bigger? Also, maybe format the cell to
General if it's set at Text. I also think that there is a maximum character
length for cells, I want to say 256 but am not sure.

"SleepyDawn" wrote:

I have been using Excel (XP) to make a text chart for several months. Some of
my text entries are rather lengthy. The past two weeks these lengthy entries
are showing up as pound signs (#########) when I click off the cell. I know
the text will fit in the cell, and the problem isn't solved by making the
cell bigger or using a little bit less text. I have the cells formatted as
"text" and "wrap to fit". I have printed the pages and the printed version
also has pound signs. I just want my text to show up!

I think you got the answer correct with the "format as General" suggestion.

But since xl97, you can put 32k characters in a cell. If you leave excel to its
own devices, you'll be able to see about 1000 characters. But you can add a
bunch of alt-enters (to force new lines in the cell) and see tons more.

Sharon wrote:

Have you tried making the row height bigger? Also, maybe format the cell to
General if it's set at Text. I also think that there is a maximum character
length for cells, I want to say 256 but am not sure.

"SleepyDawn" wrote:

I have been using Excel (XP) to make a text chart for several months. Some of
my text entries are rather lengthy. The past two weeks these lengthy entries
are showing up as pound signs (#########) when I click off the cell. I know
the text will fit in the cell, and the problem isn't solved by making the
cell bigger or using a little bit less text. I have the cells formatted as
"text" and "wrap to fit". I have printed the pages and the printed version
also has pound signs. I just want my text to show up!

--

Dave Peterson