Sounds as if you've given the cell Text number format. Change it to
General.

--
Jim
"Rockitman" wrote in message
...
|I have created a couple of big cells for text. I have word wrap on and if
I
| type in at least 2 lines of text, when I tab out of the box, the text is
| turned into a single row of # characters that go across the first line of
the
| box.
| If I double click into the cell again, the text reappears, but as soon as
I
| click outside, the # characters come back.
| I have tried adjusting the right edge of the box out to the right some,
and
| this is not doing anything to fix.
| Any ideas?