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
|