Excel Problem

[shelly24]

Hi, I hope someone can help me. I think it is probably a simple option that is set that I don't know about. Someone in my office has a spreadsheet. It contains dollar amounts and customer names the first 2 rows are title rows that tell you what is in the row. Somehow the words are not there and when we type they do not show up. You can see them in the formula bar but not in the cells. When you go to print preview sometimes you can see the words that way. What could cause this. Thank you for any help.

 

[Rockn]

The cells are either hidden or someone has changed the font color to white..

 

[shelly24]

Rockn, Thank you I think it must have been the font color. We deleted the rows and inserted new ones before I saw your reply. But when I used white font on another spreadsheet it did the same thing. Smart thinking. Thank's again.

 

[Anne Troy]

Just to make you aware.

If you put a custom format on cells, and type:

;;;

into the custom format bar, this also hides the cell contents. I think you only need two semi-colons in Excel 97. I tried it in 2K and thought they might have removed the option, but there it was when I tried three.

 

[shelly24]

Dreamboat, Thank you for your reply. I did try that in excel and you are correct. If you put three semi-colons in the custom format box it does hide the contents of the cell. But with the problem I was having when I typed in the cell you could not see any characters at all displayed as you typed. With the custom format you mentioned you can see the characters as you type but as soon as you hit enter or tab and go to a different cell the characters are hidden. So I think the problem must have been the white font color. Thank's again.