Microsoft KB Archive/173064: Difference between revisions
(importing KB archive) |
m (Text replacement - """ to """) |
||
Line 29: | Line 29: | ||
== CAUSE == | == CAUSE == | ||
This behavior occurs when you enter an improper time value, where the minutes are greater than or equal to 60. For example if you type ''' | This behavior occurs when you enter an improper time value, where the minutes are greater than or equal to 60. For example if you type '''"5:62"''' (without the quotation marks), the cell displays "0.251389" | ||
<br /> | <br /> | ||
Line 60: | Line 60: | ||
'''number formats, in cells'''<br /> | '''number formats, in cells'''<br /> | ||
<br /> | <br /> | ||
and then double-click the selected text. Click to select | and then double-click the selected text. Click to select "Change the way Microsoft Excel displays numbers, dates, and times" and click Display. | ||
Additional query words: XL97 | Additional query words: XL97 |
Latest revision as of 11:06, 21 July 2020
XL: General Number Format Applied to Improper Time Entry |
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95, versions 7.0, 7.0a
- Microsoft Excel for Windows, versions 5.0, 5.0a, 5.0c
SYMPTOMS
In Microsoft Excel, when you enter a time into a cell, the cell may change to the General number format, and display a decimal number.
CAUSE
This behavior occurs when you enter an improper time value, where the minutes are greater than or equal to 60. For example if you type "5:62" (without the quotation marks), the cell displays "0.251389"
WORKAROUND
To work around this problem, change the cell to the Time number format. To do this, follow these steps:
- Click to select the cell.
- On the Format menu, click Cells.
- On the Number tab, click Time in the Category list, and then click the time format you want in the Type list. Click OK.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.
REFERENCES
For more information about formatting, click the Index tab in Microsoft Excel Help, type the following text
number formats, in cells
and then double-click the selected text. Click to select "Change the way Microsoft Excel displays numbers, dates, and times" and click Display.
Additional query words: XL97
Keywords : xlformat
Version : WINDOWS:5.0,5.0a,5.0c,7.0,7.0a,97
Platform : WINDOWS
Issue type : kbbug
Technology :
Last Reviewed: November 16, 1999 |