Missing Text

[etarui]

Not sure if this has already been addressed, as I wasn't able to find this problem through searching this forum. Sometimes, when I open files created by others (more than a one off), certain text is not viewable in the cell. However, the contents are there, and can be seen in the Formula Bar, and will be visible if the file is printed. This is NOT a formatting issue, as I have tried changing font properties as well as cell properties, and both have been unsuccessful in resolving the issue. I have also tried uninstalling and reinstalling Excel with no success. This problem hasn't occurred on spreadsheets authored by me. Here are a couple of screen-shots to illustrate:

Here is information related to what I am running:
Windows XP Pro - Version 2002
Service Pack 2
Excel 2003 (Part of Office Pro Edition)

Thanks in advance for any suggestions!

 

[KenCriss]

Are you sure on the Font tab that the color is not set to white?

Also is there any code in the Sheet module or Workbook module that might be causing this to happen?

 

[etarui]

Are you sure on the Font tab that the color is not set to white?

Also is there any code in the Sheet module or Workbook module that might be causing this to happen?

I am positive it is not formatted any differently than any other text on the page. There are no Macros or code within the Sheet or Workbook.

This one has me stumped!

 

[Norie]

Have you checked Format>Conditional formatting...?

 

[NBVC]

Have you checked to see if there is any Conditional Formatting set on those cells?

Format|Conditional Formatting

 

[etarui]

Have you checked Format>Conditional formatting...?

Yup - No Format Has Been Set.

 

[NBVC]

So there is no chance either that the cell formatting could be custom set to ;;; ?


....can't really think of anything else....except if there is some version conflicts