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.

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.

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.

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.

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.

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.

Format the cell as General.

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.

--

Dave Peterson

I tried that one and it didn't fix the problem. Thanks for the suggestion.

"Dave Peterson" wrote:

Format the cell as General.

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.

--

Dave Peterson

Dave:

Even though we were able to solve to OP's problem by trail and error. I
still don't know what actually caused the mis-behavior in the first place!
--
Gary''s Student


"mommyo" wrote:

I tried that one and it didn't fix the problem. Thanks for the suggestion.

"Dave Peterson" wrote:

Format the cell as General.

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.

--

Dave Peterson

I wonder if mommyo copied a cell that was formatted as General and pasted over
that troublesome cell--changing it to general.

(I don't recall ever seeing formatting the cell as general not work when the
problem is too long of text in the cell.)

But glad you guys have it worked out.

Gary''s Student wrote:

Dave:

Even though we were able to solve to OP's problem by trail and error. I
still don't know what actually caused the mis-behavior in the first place!
--
Gary''s Student

"mommyo" wrote:

I tried that one and it didn't fix the problem. Thanks for the suggestion.

"Dave Peterson" wrote:

Format the cell as General.

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.

--

Dave Peterson


--

Dave Peterson

The cell already contained text and you could read it. I just went into edit
mode to change a few things and when I hit enter the cell showed x's.

"Dave Peterson" wrote:

I wonder if mommyo copied a cell that was formatted as General and pasted over
that troublesome cell--changing it to general.

(I don't recall ever seeing formatting the cell as general not work when the
problem is too long of text in the cell.)

But glad you guys have it worked out.

Gary''s Student wrote:

Dave:

Even though we were able to solve to OP's problem by trail and error. I
still don't know what actually caused the mis-behavior in the first place!
--
Gary''s Student

"mommyo" wrote:

I tried that one and it didn't fix the problem. Thanks for the suggestion.

"Dave Peterson" wrote:

Format the cell as General.

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.

--

Dave Peterson


--

Dave Peterson