Just some nutty things to discount...
What is the numberformat for the cell?
Try changing it to General.
(format|cells|Number tab)
When you say the text disappears, does the cell look empty or what?
Mark_GS1CA wrote:
Hi David,
Thanks for your response. That was in fact the first thing I tried. There
are no merged cells on the sheet.
I start with a completly blank sheet, I enter any amount of text and the
instant I apply word wrap to eith ther the cell or the column ( I have tried
both seperatly) the text disappears from the screen.
Thanks again
"David McRitchie" wrote:
Hi Mark,
Widen the column, to what you want then use autofit on the row(s)
not on the column. If you have merged cells involved you will have
to adjust the row height other than by autofit. Once you have manually
changed the row height you stuck with having to manually adjust
in future usage.
-
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Mark_GS1CA" wrote in message ...
I am haveing a problem with Excel.
Whenever word wrap is applied the text is not visable in the cell. It
remains visable only in the bar above.
I have already confirmed autofit and it reduces the column to 1 character
wide.
I tried detect and repair on the installation and nothing.
I even upgraded from Excel 2k to Excel 2003 and no change.
I would greatly appreciate help on this as it is really bugging me.
--
Dave Peterson