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