Missing Text

etarui

New Member
Joined
Sep 28, 2006
Messages
3
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!
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

KenCriss

Active Member
Joined
Jun 6, 2005
Messages
323
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

New Member
Joined
Sep 28, 2006
Messages
3
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

Well-known Member
Joined
Apr 28, 2004
Messages
75,930
Office Version
  1. 365
Platform
  1. Windows
Have you checked Format>Conditional formatting...?
 

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828

ADVERTISEMENT

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

Format|Conditional Formatting
 

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
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 :confused:
 

Watch MrExcel Video

Forum statistics

Threads
1,114,400
Messages
5,547,735
Members
410,809
Latest member
lilwayne
Top