View Single Post
  #6   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc
Shannon Jacobs Shannon Jacobs is offline
external usenet poster
 
Posts: 7
Default Disappearing text in Excel cells

The original formatting of the cells was General, but I tried Text just to
see if that helped. I actually went back to the original file a couple of
times, trying to find something in it that could have been globally changed,
or tweaked on a column or row basis. Nothing I did made it better. Of course
turning off the word wrap worked in the sense that the text became a single
line running out of the cell, but that was no solution to being unable to
read the file, even though I could edit it without any obvious problems. As
long as I was in the cell, the data appeared normally visible...

Hoping to find out how the troublesome file was created, I've sent a query
to the person who sent it to me, but she hasn't responded yet.

Pete_UK wrote:
Dave's point 3:

If the cells were formatted as Text and you do Format | Cells etc to
change them to General, the change does not come into effect until you
edit the cells - press F2 or click in the formula bar as if to edit,
then click elsewhere.

I see that you have found a solution by using Word, but if you do go
back to Excel then confirm that the formatting has been changed to
General.

Hope this helps.

<older snipped