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:

e5.jpg


B3.jpg


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!
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

KenCriss

Active Member
Joined
Jun 6, 2005
Messages
326
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
76,351
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:
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,127
Messages
5,857,525
Members
431,883
Latest member
Hien

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top