Microsoft KB Archive/42288

-

{| 2.x 3.00 4.00 | 2.20 2.21 3.00 | 2.20 3.00 4.00 WINDOWS      | OS/2           | MACINTOSH kbusage The information in this article applies to:
 * width="100%"|


 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0
 * Microsoft Excel for the Macintosh, versions 2.2, 3.0, 4.0
 * Microsoft Excel for OS/2, versions 2.2, 2.21, 3.0

SYMPTOMS
When creating and saving a chart using information formatted with a custom date format, the dates no longer appear when the chart is reopened. Their serial number representations are displayed.

NOTE: This problem does not occur in later versions of Microsoft Excel.

CAUSE
The supporting sheet (the sheet from which the chart was created) is not open.

WORKAROUND
Once you have both the worksheet and the chart open, the custom date formats display correctly.
 * }

-

Last reviewed: December 2, 1994

© 1998 Microsoft Corporation. All rights reserved. Terms of Use.