XL98: Number Signs (###) Displayed in Cells of a Worksheet That Contain Dates

• Microsoft Excel 98 Macintosh Edition

SYMPTOMS

When you open an existing worksheet, you see number signs (###) in cells that contain dates.

CAUSE

The behavior occurs when the following conditions are true:

1. You clear the Show century check box in the Date & Time Control Panel.



2. You type dates in a workbook including the day, month and year, using the dash (-) or slash mark (/) separators in one or more cells.



3. You do not click Cells on the Format menu to change the number format. You leave the date formatted as the default number format.



4. You adjust the column width just wide enough to display the date in the cell.



5. You close the workbook.



6. You select the Show century check box in the Date & Time Control Panel.



7. You reopen the workbook.

WORKAROUND

With the cell selected, point to Column on the Format menu and click AutoFit Selection to widen the column to display the newly formatted dates.

NOTE: After you widen the columns, worksheets may be printed differently. Check your print settings after the changes.

MORE INFORMATION

Microsoft Excel uses the Date & Time Control Panel to determine what number formats to use and the correct separators to use (for example "/" or "-"). These settings affect the way Microsoft Excel displays and uses dates and times. If you type a date in a cell and do not click Cells on the Format menu to choose a number format, Excel defaults to the Short Date format in the Date & Time Control Panel. When the Short Date format changes, the date format automatically changes in the cells in Excel.

REFERENCES

For additional information about how Microsoft Excel works with two-digit year numbers, click the article number below to view the article in the Microsoft Knowledge Base:

Q164406 XL: How Microsoft Excel Works with Two-Digit Year Numbers

Additional query words: XL98 Y2K pound key

Keywords : kbdta kb2000
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb