Text disappears when word wrap is used

Was anyone ever able to solve this issue? I am having the exact same
problem. I can't find anything on it in the MS KB.

"Mark_GS1CA" wrote:

> Hi David
>
> Thanks for your time in replying.
>
> I am using Excel 2003 SP1 on XP Pro SP2
>
> I open a brand new work sheet in safe mode
> I type a line in a cell
> I right click cell: format: alignment: click word wrap annd...
> poof the text in the cell disappears
>
> I too have never seen the like, however this problem persists even after a
> reinstall of Office.
>
> I guess I will have to try a repair on the OS and hope that its a shared dll
> somewhere thats corrupted.
>
> Thanks,
>
>
>
>
> "David McRitchie" wrote:
>
> > Hi Mark,
> > Check that the formatting is still General and not something that would
> > suppress display like all semicolons
> >
> > Make sure that there is not Conditional Formatting in Effect
> > if you don't see any, make sure
> > select all cells (ctrl+shift+spacebar even in Excel 2003)
> > format, Conditional Format, delete button , check all three and delete
> >
> > Make sure that the font is still black for automatic
> >
> > Try opening in "Safe Mode" which disables macros and add-ins.
> > http://www.mvps.org/dmcritchie/excel/slowresp.htm
> >
> > I can't find anything in web searches to match your problem, well actually
> > I trying to specifically look for Excel 2003.
> >
> > What version of Excel do you have.
> >
> > Try clearing out your temporary internet file (from Internet Explorer), are
> > you short on disk space.
> >
> > ---
> > 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" <MarkGS1CA@discussions.microsoft.com> wrote in message news:22E3795C-4DA2-4540-8BAA-94C8E2C52D67@microsoft.com...
> > > 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" <Mark_GS1CA@discussions.microsoft.com> wrote in message news:9A49D784-3EDB-4CA7-8265-194B9CF6F852@microsoft.com...
> > > > > 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.
> > > > >
> > > > >
> > > >
> > > >
> > > >
> >
> >
> >

Try adding alt-enters (to force new lines within the cell) every 80-100
characters.

You may have to resize that rowheight (if the text is really, really long).

Daniel Felkins wrote:
>
> Was anyone ever able to solve this issue? I am having the exact same
> problem. I can't find anything on it in the MS KB.
>
> "Mark_GS1CA" wrote:
>
> > Hi David
> >
> > Thanks for your time in replying.
> >
> > I am using Excel 2003 SP1 on XP Pro SP2
> >
> > I open a brand new work sheet in safe mode
> > I type a line in a cell
> > I right click cell: format: alignment: click word wrap annd...
> > poof the text in the cell disappears
> >
> > I too have never seen the like, however this problem persists even after a
> > reinstall of Office.
> >
> > I guess I will have to try a repair on the OS and hope that its a shared dll
> > somewhere thats corrupted.
> >
> > Thanks,
> >
> >
> >
> >
> > "David McRitchie" wrote:
> >
> > > Hi Mark,
> > > Check that the formatting is still General and not something that would
> > > suppress display like all semicolons
> > >
> > > Make sure that there is not Conditional Formatting in Effect
> > > if you don't see any, make sure
> > > select all cells (ctrl+shift+spacebar even in Excel 2003)
> > > format, Conditional Format, delete button , check all three and delete
> > >
> > > Make sure that the font is still black for automatic
> > >
> > > Try opening in "Safe Mode" which disables macros and add-ins.
> > > http://www.mvps.org/dmcritchie/excel/slowresp.htm
> > >
> > > I can't find anything in web searches to match your problem, well actually
> > > I trying to specifically look for Excel 2003.
> > >
> > > What version of Excel do you have.
> > >
> > > Try clearing out your temporary internet file (from Internet Explorer), are
> > > you short on disk space.
> > >
> > > ---
> > > 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" <MarkGS1CA@discussions.microsoft.com> wrote in message news:22E3795C-4DA2-4540-8BAA-94C8E2C52D67@microsoft.com...
> > > > 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" <Mark_GS1CA@discussions.microsoft.com> wrote in message news:9A49D784-3EDB-4CA7-8265-194B9CF6F852@microsoft.com...
> > > > > > 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

Thanks for the reply!

I have this issue with cells that have even less than 15 characters in them.
Adding the alt-enters don't seem to help. I think that similar to Mark
there must be a .dll or something causing this. It now happens even when I
open an excel sheet that someone else created. Took me quite awhile to even
figure out that the issue was word wrap. But for some reason if I turn on
word wrap the contents are not visible in cell, yet the contents can be seen
on the formula bar. For example, if I close down excel, open a new workbook
type "The quick brown" into a cell then go to cell properties, place a check
mark in wrap text, click on ok. The moment I click on ok the text disappears
from the cell. I am really baffled by this. I have never had the issue
before and I don't know exactly when it started so I can't even for sure say
what I might have changed on my laptop to cause it.

Thanks for any advice you can give to track this down.

"Dave Peterson" wrote:

> Try adding alt-enters (to force new lines within the cell) every 80-100
> characters.
>
> You may have to resize that rowheight (if the text is really, really long).
>
> Daniel Felkins wrote:
> >
> > Was anyone ever able to solve this issue? I am having the exact same
> > problem. I can't find anything on it in the MS KB.
> >
> > "Mark_GS1CA" wrote:
> >
> > > Hi David
> > >
> > > Thanks for your time in replying.
> > >
> > > I am using Excel 2003 SP1 on XP Pro SP2
> > >
> > > I open a brand new work sheet in safe mode
> > > I type a line in a cell
> > > I right click cell: format: alignment: click word wrap annd...
> > > poof the text in the cell disappears
> > >
> > > I too have never seen the like, however this problem persists even after a
> > > reinstall of Office.
> > >
> > > I guess I will have to try a repair on the OS and hope that its a shared dll
> > > somewhere thats corrupted.
> > >
> > > Thanks,
> > >
> > >
> > >
> > >
> > > "David McRitchie" wrote:
> > >
> > > > Hi Mark,
> > > > Check that the formatting is still General and not something that would
> > > > suppress display like all semicolons
> > > >
> > > > Make sure that there is not Conditional Formatting in Effect
> > > > if you don't see any, make sure
> > > > select all cells (ctrl+shift+spacebar even in Excel 2003)
> > > > format, Conditional Format, delete button , check all three and delete
> > > >
> > > > Make sure that the font is still black for automatic
> > > >
> > > > Try opening in "Safe Mode" which disables macros and add-ins.
> > > > http://www.mvps.org/dmcritchie/excel/slowresp.htm
> > > >
> > > > I can't find anything in web searches to match your problem, well actually
> > > > I trying to specifically look for Excel 2003.
> > > >
> > > > What version of Excel do you have.
> > > >
> > > > Try clearing out your temporary internet file (from Internet Explorer), are
> > > > you short on disk space.
> > > >
> > > > ---
> > > > 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" <MarkGS1CA@discussions.microsoft.com> wrote in message news:22E3795C-4DA2-4540-8BAA-94C8E2C52D67@microsoft.com...
> > > > > 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" <Mark_GS1CA@discussions.microsoft.com> wrote in message news:9A49D784-3EDB-4CA7-8265-194B9CF6F852@microsoft.com...
> > > > > > > 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
>

Are you sure it disappears?

If you adjust the rowheight, do you see all the text?

Daniel Felkins wrote:
>
> Thanks for the reply!
>
> I have this issue with cells that have even less than 15 characters in them.
> Adding the alt-enters don't seem to help. I think that similar to Mark
> there must be a .dll or something causing this. It now happens even when I
> open an excel sheet that someone else created. Took me quite awhile to even
> figure out that the issue was word wrap. But for some reason if I turn on
> word wrap the contents are not visible in cell, yet the contents can be seen
> on the formula bar. For example, if I close down excel, open a new workbook
> type "The quick brown" into a cell then go to cell properties, place a check
> mark in wrap text, click on ok. The moment I click on ok the text disappears
> from the cell. I am really baffled by this. I have never had the issue
> before and I don't know exactly when it started so I can't even for sure say
> what I might have changed on my laptop to cause it.
>
> Thanks for any advice you can give to track this down.
>
> "Dave Peterson" wrote:
>
> > Try adding alt-enters (to force new lines within the cell) every 80-100
> > characters.
> >
> > You may have to resize that rowheight (if the text is really, really long).
> >
> > Daniel Felkins wrote:
> > >
> > > Was anyone ever able to solve this issue? I am having the exact same
> > > problem. I can't find anything on it in the MS KB.
> > >
> > > "Mark_GS1CA" wrote:
> > >
> > > > Hi David
> > > >
> > > > Thanks for your time in replying.
> > > >
> > > > I am using Excel 2003 SP1 on XP Pro SP2
> > > >
> > > > I open a brand new work sheet in safe mode
> > > > I type a line in a cell
> > > > I right click cell: format: alignment: click word wrap annd...
> > > > poof the text in the cell disappears
> > > >
> > > > I too have never seen the like, however this problem persists even after a
> > > > reinstall of Office.
> > > >
> > > > I guess I will have to try a repair on the OS and hope that its a shared dll
> > > > somewhere thats corrupted.
> > > >
> > > > Thanks,
> > > >
> > > >
> > > >
> > > >
> > > > "David McRitchie" wrote:
> > > >
> > > > > Hi Mark,
> > > > > Check that the formatting is still General and not something that would
> > > > > suppress display like all semicolons
> > > > >
> > > > > Make sure that there is not Conditional Formatting in Effect
> > > > > if you don't see any, make sure
> > > > > select all cells (ctrl+shift+spacebar even in Excel 2003)
> > > > > format, Conditional Format, delete button , check all three and delete
> > > > >
> > > > > Make sure that the font is still black for automatic
> > > > >
> > > > > Try opening in "Safe Mode" which disables macros and add-ins.
> > > > > http://www.mvps.org/dmcritchie/excel/slowresp.htm
> > > > >
> > > > > I can't find anything in web searches to match your problem, well actually
> > > > > I trying to specifically look for Excel 2003.
> > > > >
> > > > > What version of Excel do you have.
> > > > >
> > > > > Try clearing out your temporary internet file (from Internet Explorer), are
> > > > > you short on disk space.
> > > > >
> > > > > ---
> > > > > 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" <MarkGS1CA@discussions.microsoft.com> wrote in message news:22E3795C-4DA2-4540-8BAA-94C8E2C52D67@microsoft.com...
> > > > > > 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" <Mark_GS1CA@discussions.microsoft.com> wrote in message news:9A49D784-3EDB-4CA7-8265-194B9CF6F852@microsoft.com...
> > > > > > > > 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
> >

--

Dave Peterson

I am very sure it "disappears". Adjusting the rowheight has no effect.
Adjusting the column width has no effect.

"Dave Peterson" wrote:

> Are you sure it disappears?
>
> If you adjust the rowheight, do you see all the text?
>
> Daniel Felkins wrote:
> >
> > Thanks for the reply!
> >
> > I have this issue with cells that have even less than 15 characters in them.
> > Adding the alt-enters don't seem to help. I think that similar to Mark
> > there must be a .dll or something causing this. It now happens even when I
> > open an excel sheet that someone else created. Took me quite awhile to even
> > figure out that the issue was word wrap. But for some reason if I turn on
> > word wrap the contents are not visible in cell, yet the contents can be seen
> > on the formula bar. For example, if I close down excel, open a new workbook
> > type "The quick brown" into a cell then go to cell properties, place a check
> > mark in wrap text, click on ok. The moment I click on ok the text disappears
> > from the cell. I am really baffled by this. I have never had the issue
> > before and I don't know exactly when it started so I can't even for sure say
> > what I might have changed on my laptop to cause it.
> >
> > Thanks for any advice you can give to track this down.
> >
> > "Dave Peterson" wrote:
> >
> > > Try adding alt-enters (to force new lines within the cell) every 80-100
> > > characters.
> > >
> > > You may have to resize that rowheight (if the text is really, really long).
> > >
> > > Daniel Felkins wrote:
> > > >
> > > > Was anyone ever able to solve this issue? I am having the exact same
> > > > problem. I can't find anything on it in the MS KB.
> > > >
> > > > "Mark_GS1CA" wrote:
> > > >
> > > > > Hi David
> > > > >
> > > > > Thanks for your time in replying.
> > > > >
> > > > > I am using Excel 2003 SP1 on XP Pro SP2
> > > > >
> > > > > I open a brand new work sheet in safe mode
> > > > > I type a line in a cell
> > > > > I right click cell: format: alignment: click word wrap annd...
> > > > > poof the text in the cell disappears
> > > > >
> > > > > I too have never seen the like, however this problem persists even after a
> > > > > reinstall of Office.
> > > > >
> > > > > I guess I will have to try a repair on the OS and hope that its a shared dll
> > > > > somewhere thats corrupted.
> > > > >
> > > > > Thanks,
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > "David McRitchie" wrote:
> > > > >
> > > > > > Hi Mark,
> > > > > > Check that the formatting is still General and not something that would
> > > > > > suppress display like all semicolons
> > > > > >
> > > > > > Make sure that there is not Conditional Formatting in Effect
> > > > > > if you don't see any, make sure
> > > > > > select all cells (ctrl+shift+spacebar even in Excel 2003)
> > > > > > format, Conditional Format, delete button , check all three and delete
> > > > > >
> > > > > > Make sure that the font is still black for automatic
> > > > > >
> > > > > > Try opening in "Safe Mode" which disables macros and add-ins.
> > > > > > http://www.mvps.org/dmcritchie/excel/slowresp.htm
> > > > > >
> > > > > > I can't find anything in web searches to match your problem, well actually
> > > > > > I trying to specifically look for Excel 2003.
> > > > > >
> > > > > > What version of Excel do you have.
> > > > > >
> > > > > > Try clearing out your temporary internet file (from Internet Explorer), are
> > > > > > you short on disk space.
> > > > > >
> > > > > > ---
> > > > > > 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" <MarkGS1CA@discussions.microsoft.com> wrote in message news:22E3795C-4DA2-4540-8BAA-94C8E2C52D67@microsoft.com...
> > > > > > > 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" <Mark_GS1CA@discussions.microsoft.com> wrote in message news:9A49D784-3EDB-4CA7-8265-194B9CF6F852@microsoft.com...
> > > > > > > > > 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
> > >
>
> --
>
> Dave Peterson
>

I've never seen values disappear from the cell just when wordwrap is toggled on.

Silly guess...
Since you can see the value still in the formula bar, is there any chance that
the numberformat for that cell changed?

A custom format of: ;;;
would hide the value in the cell

(or white font on white background -- silly guess #2!)



Daniel Felkins wrote:
>
> I am very sure it "disappears". Adjusting the rowheight has no effect.
> Adjusting the column width has no effect.
>
> "Dave Peterson" wrote:
>
> > Are you sure it disappears?
> >
> > If you adjust the rowheight, do you see all the text?
> >
> > Daniel Felkins wrote:
> > >
> > > Thanks for the reply!
> > >
> > > I have this issue with cells that have even less than 15 characters in them.
> > > Adding the alt-enters don't seem to help. I think that similar to Mark
> > > there must be a .dll or something causing this. It now happens even when I
> > > open an excel sheet that someone else created. Took me quite awhile to even
> > > figure out that the issue was word wrap. But for some reason if I turn on
> > > word wrap the contents are not visible in cell, yet the contents can be seen
> > > on the formula bar. For example, if I close down excel, open a new workbook
> > > type "The quick brown" into a cell then go to cell properties, place a check
> > > mark in wrap text, click on ok. The moment I click on ok the text disappears
> > > from the cell. I am really baffled by this. I have never had the issue
> > > before and I don't know exactly when it started so I can't even for sure say
> > > what I might have changed on my laptop to cause it.
> > >
> > > Thanks for any advice you can give to track this down.
> > >
> > > "Dave Peterson" wrote:
> > >
> > > > Try adding alt-enters (to force new lines within the cell) every 80-100
> > > > characters.
> > > >
> > > > You may have to resize that rowheight (if the text is really, really long).
> > > >
> > > > Daniel Felkins wrote:
> > > > >
> > > > > Was anyone ever able to solve this issue? I am having the exact same
> > > > > problem. I can't find anything on it in the MS KB.
> > > > >
> > > > > "Mark_GS1CA" wrote:
> > > > >
> > > > > > Hi David
> > > > > >
> > > > > > Thanks for your time in replying.
> > > > > >
> > > > > > I am using Excel 2003 SP1 on XP Pro SP2
> > > > > >
> > > > > > I open a brand new work sheet in safe mode
> > > > > > I type a line in a cell
> > > > > > I right click cell: format: alignment: click word wrap annd...
> > > > > > poof the text in the cell disappears
> > > > > >
> > > > > > I too have never seen the like, however this problem persists even after a
> > > > > > reinstall of Office.
> > > > > >
> > > > > > I guess I will have to try a repair on the OS and hope that its a shared dll
> > > > > > somewhere thats corrupted.
> > > > > >
> > > > > > Thanks,
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > "David McRitchie" wrote:
> > > > > >
> > > > > > > Hi Mark,
> > > > > > > Check that the formatting is still General and not something that would
> > > > > > > suppress display like all semicolons
> > > > > > >
> > > > > > > Make sure that there is not Conditional Formatting in Effect
> > > > > > > if you don't see any, make sure
> > > > > > > select all cells (ctrl+shift+spacebar even in Excel 2003)
> > > > > > > format, Conditional Format, delete button , check all three and delete
> > > > > > >
> > > > > > > Make sure that the font is still black for automatic
> > > > > > >
> > > > > > > Try opening in "Safe Mode" which disables macros and add-ins.
> > > > > > > http://www.mvps.org/dmcritchie/excel/slowresp.htm
> > > > > > >
> > > > > > > I can't find anything in web searches to match your problem, well actually
> > > > > > > I trying to specifically look for Excel 2003.
> > > > > > >
> > > > > > > What version of Excel do you have.
> > > > > > >
> > > > > > > Try clearing out your temporary internet file (from Internet Explorer), are
> > > > > > > you short on disk space.
> > > > > > >
> > > > > > > ---
> > > > > > > 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" <MarkGS1CA@discussions.microsoft.com> wrote in message news:22E3795C-4DA2-4540-8BAA-94C8E2C52D67@microsoft.com...
> > > > > > > > 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" <Mark_GS1CA@discussions.microsoft.com> wrote in message news:9A49D784-3EDB-4CA7-8265-194B9CF6F852@microsoft.com...
> > > > > > > > > > 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
> > > >
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson

Is it possible that the default text properties have the text color set
to white?
When you click on the cell after typing text into it, do you see your
text at the top in the formula area, which is to the right of the cell
number?




Dave Peterson wrote:
> I've never seen values disappear from the cell just when wordwrap is toggled on.
>
> Silly guess...
> Since you can see the value still in the formula bar, is there any chance that
> the numberformat for that cell changed?
>
> A custom format of: ;;;
> would hide the value in the cell
>
> (or white font on white background -- silly guess #2!)
>
>
>
> Daniel Felkins wrote:
> >
> > I am very sure it "disappears". Adjusting the rowheight has no effect.
> > Adjusting the column width has no effect.
> >
> > "Dave Peterson" wrote:
> >
> > > Are you sure it disappears?
> > >
> > > If you adjust the rowheight, do you see all the text?
> > >
> > > Daniel Felkins wrote:
> > > >
> > > > Thanks for the reply!
> > > >
> > > > I have this issue with cells that have even less than 15 characters in them.
> > > > Adding the alt-enters don't seem to help. I think that similar to Mark
> > > > there must be a .dll or something causing this. It now happens even when I
> > > > open an excel sheet that someone else created. Took me quite awhile to even
> > > > figure out that the issue was word wrap. But for some reason if I turn on
> > > > word wrap the contents are not visible in cell, yet the contents can be seen
> > > > on the formula bar. For example, if I close down excel, open a new workbook
> > > > type "The quick brown" into a cell then go to cell properties, place a check
> > > > mark in wrap text, click on ok. The moment I click on ok the text disappears
> > > > from the cell. I am really baffled by this. I have never had the issue
> > > > before and I don't know exactly when it started so I can't even for sure say
> > > > what I might have changed on my laptop to cause it.
> > > >
> > > > Thanks for any advice you can give to track this down.
> > > >
> > > > "Dave Peterson" wrote:
> > > >
> > > > > Try adding alt-enters (to force new lines within the cell) every 80-100
> > > > > characters.
> > > > >
> > > > > You may have to resize that rowheight (if the text is really, really long).
> > > > >
> > > > > Daniel Felkins wrote:
> > > > > >
> > > > > > Was anyone ever able to solve this issue? I am having the exact same
> > > > > > problem. I can't find anything on it in the MS KB.
> > > > > >
> > > > > > "Mark_GS1CA" wrote:
> > > > > >
> > > > > > > Hi David
> > > > > > >
> > > > > > > Thanks for your time in replying.
> > > > > > >
> > > > > > > I am using Excel 2003 SP1 on XP Pro SP2
> > > > > > >
> > > > > > > I open a brand new work sheet in safe mode
> > > > > > > I type a line in a cell
> > > > > > > I right click cell: format: alignment: click word wrap annd...
> > > > > > > poof the text in the cell disappears
> > > > > > >
> > > > > > > I too have never seen the like, however this problem persists even after a
> > > > > > > reinstall of Office.
> > > > > > >
> > > > > > > I guess I will have to try a repair on the OS and hope that its a shared dll
> > > > > > > somewhere thats corrupted.
> > > > > > >
> > > > > > > Thanks,
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > "David McRitchie" wrote:
> > > > > > >
> > > > > > > > Hi Mark,
> > > > > > > > Check that the formatting is still General and not something that would
> > > > > > > > suppress display like all semicolons
> > > > > > > >
> > > > > > > > Make sure that there is not Conditional Formatting in Effect
> > > > > > > > if you don't see any, make sure
> > > > > > > > select all cells (ctrl+shift+spacebar even in Excel 2003)
> > > > > > > > format, Conditional Format, delete button , check all three and delete
> > > > > > > >
> > > > > > > > Make sure that the font is still black for automatic
> > > > > > > >
> > > > > > > > Try opening in "Safe Mode" which disables macros and add-ins.
> > > > > > > > http://www.mvps.org/dmcritchie/excel/slowresp.htm
> > > > > > > >
> > > > > > > > I can't find anything in web searches to match your problem, well actually
> > > > > > > > I trying to specifically look for Excel 2003.
> > > > > > > >
> > > > > > > > What version of Excel do you have.
> > > > > > > >
> > > > > > > > Try clearing out your temporary internet file (from Internet Explorer), are
> > > > > > > > you short on disk space.
> > > > > > > >
> > > > > > > > ---
> > > > > > > > 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" <MarkGS1CA@discussions.microsoft.com> wrote in message news:22E3795C-4DA2-4540-8BAA-94C8E2C52D67@microsoft.com...
> > > > > > > > > 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" <Mark_GS1CA@discussions.microsoft.com> wrote in message news:9A49D784-3EDB-4CA7-8265-194B9CF6F852@microsoft.com...
> > > > > > > > > > > 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
> > > > >
> > >
> > > --
> > >
> > > Dave Peterson
> > >
>
> --
>
> Dave Peterson