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