Microsoft KB Archive/132967

{|
 * width="100%"|

XL: Dates and Times Displayed as Serial Numbers When Viewing Formulas

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 5.0, 5.0c
 * Microsoft Excel for the Macintosh, versions 5.0, 5.0a
 * Microsoft Excel for Windows 95, version 7.0
 * Microsoft Excel 97 for Windows
 * Microsoft Excel 98 Macintosh Edition

-

SYMPTOMS
Microsoft Excel displays serial number values for dates and times in cells, but shows formatted dates and times in the formula bar.

CAUSE
This behavior occurs when you are viewing your worksheet as formulas rather than values.

RESOLUTION
To display formatted dates and times in the cells on the worksheet:


 * 1) On the Tools menu, click Options, or if you are using a Macintosh, click Preferences.
 * 2) On the View tab, click to clear (remove the "x" from) the Formulas check box.

MORE INFORMATION
The Formulas check box is used to view formulas in the cells on the worksheet, as well as in the formula bar.

How Microsoft Excel Stores Dates and Times
Microsoft Excel stores dates as sequential numbers known as serial values. Excel stores times as decimal fractions because time is considered a portion of a day. Dates and times are values and so you can add, subtract, and include dates and times in other calculations. For example, to determine the difference between two dates, you can subtract one date from the other. You can view a date as a serial value and a time as a decimal fraction by changing the format of the cell that contains the date or time to General format.

Additional query words: XL2000 5.00 5.00a 5.00c 7.00 97 XL97

Keywords :

Version : MACINTOSH:5.0,5.0a,98; WINDOWS:5.0,5.0c,7.0,97

Platform : MACINTOSH WINDOWS

Issue type : kbprb

Technology :