This is actually good news:

1. locate a good text cell, copy it
2. paste it into a cell having pound problems
3. hopefully, the pound cell should now match the "good" cell
4. from the formula bar, back out the copied text and then enter the desired
text
--
Gary''s Student


"mommyo" wrote:

It didn't make a difference. It's weird, because some of the cells have way
more text in them than this cell. And I made the cells the same size.

"Gary''s Student" wrote:

Have patience.

Some versions of Excel have a problem with text strings between 256 and 1024.

First save your workbook. Then edit the cell to progressively shorten it.
We need to make text that does work first.
--
Gary''s Student


"mommyo" wrote:

It didn't make a difference.

"Gary''s Student" wrote:

O.K.then...

Select one of the cells. In the formula bar, click on the very beginning of
the text, before the first character. Insert a single apostrophy ' . The
first character should be the apostrophy. Then touch enter. What happens??
--
Gary''s Student


"mommyo" wrote:

Still the same thing. I can see the text in the format bar but in the cell
it's still #.

"Gary''s Student" wrote:

Take an un-used cell and first format it as text and make sure that all of
the cells to the right of the un-used are empty.

Then copy the problem cell into the un-used cell. What happens?
--
Gary''s Student


"mommyo" wrote:

The text does show up in the formula bar.

"Gary''s Student" wrote:

If you select the cell, does the text show up in the formula bar?
--
Gary''s Student


"mommyo" wrote:

I entered text in a cell that is formatted for text and wrap. When I hit
enter it shows as pound signs. I've tried making the cell wider and taller
but that didn't help. I used the format brush to copy the format down from
the cell above...still doesn't work.