posted
It's all still there in the cells, and the column and row labels have appeared, but for some reason it wont show the data in the rest of the sheet. It's so odd, I've looked through all the options I could think of and didn't find anything that works. Anyone have any ideas? If it helps, all the data is text...
posted
What do you mean, it is still there in the cells, but the data doesn't appear? Are you seeing blank cells?
Posts: 9538 | Registered: Aug 2003
| IP: Logged |
posted
It's all part of the top-secret scheme of the ideological organization of ACROSS to take over the world. She's a crafty girl, that Excel. Well, okay, not really, but. . . .
Posts: 1814 | Registered: Jul 2004
| IP: Logged |
quote: Text or other data I enter isn't displayed in the cells.
Reset the number format The cells may be formatted so that data in the cells is hidden. To remove specific number formats that may be affecting the displayed value, select the cells. On the Format menu, click Cells, and then click the Number tab. In the Category list, click General.
Check the color of text and the background If text in a cell is the same color as the background, nothing appears in the cell. You can change the color of the background or change the color of the text.
OK, click on the box to select all cells (the one diagonally up and left of cell A1. Then, place the cursor between two column headings until it changes to the resize cursor. Double click and tell me what happened.
Posts: 26071 | Registered: Oct 2003
| IP: Logged |
posted
If the columns weren't wide enough Dag (like you're having him check) it would just appear as #### signs....
Posts: 9538 | Registered: Aug 2003
| IP: Logged |
posted
Even in the new sheet? The reason I ask is that this means the problem is definitely with the data, not the formatting, because paste special values doesn't pull that over.
Is the data confidential? I'd be happy to take a look at it and see if I can fix it.
posted
FG, text will cut off, not turn into ####. I'm thinking there's spaces or something in the front of the text, or carriage returns if the data was imported.
Posts: 26071 | Registered: Oct 2003
| IP: Logged |
[EDIT: Ha, well I loaded it up fresh and that's when it happened, but I probably used Excel in between and I'm not sure what I did then (though I didn't use merge cells)]
posted
Got it. At first glance, it looks right. I'll save it as a slightly different format and see if that fixes it for you.
Posts: 26071 | Registered: Oct 2003
| IP: Logged |
posted
I sent it back as text - you'll lose formatting. I mentioned this in the email, but have you tried rebooting?
Posts: 26071 | Registered: Oct 2003
| IP: Logged |
posted
I didn't think of it until it showed up perfectly on my screen. It's got to be Excel on his machine causing the problem, right?
Posts: 26071 | Registered: Oct 2003
| IP: Logged |
posted
OK so I've rebooted and nothing happened ... only that was a few hours ago and I just re-did it and now it's fine. Wow. Thanks FarmWoman and Dag.
posted
I need new glasses - when I first saw this thread, it looked like "Excel made my date disappear." That is so wrong.
Posts: 2034 | Registered: Apr 2004
| IP: Logged |