######### in text box
Joel
If the data is a number or date this would hold true, otherwise not.
OP states "two lines of text".
Jim's response is most likely the correct one.
Excel has a problem with cells that contain 255 but <1024 characters.
Gord Dibben MS Excel MVP
On Tue, 22 May 2007 11:42:01 -0700, Joel wrote:
try adjusting column width. You may have the column width too narrow.
"Jim Rech" wrote:
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?
|