XL: General Number Format Applied to Improper Time Entry (213901)


The information in this article applies to:

  • Microsoft Excel 2000
  • Microsoft Excel 2002
  • Microsoft Excel 97 for Windows
  • Microsoft Excel for Windows 95
  • Microsoft Excel for Windows 95 7.0a
This article was previously published under Q213901

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, the cell displays "0.251389"

WORKAROUND

To work around this problem, change the cell to the Time number format:
  1. Click to select the cell.
  2. On the Format menu, click Cells.
  3. 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 that this is a problem in the Microsoft products that are listed at the beginning of this article.

REFERENCES

For more information about number formatting, click Microsoft Excel Help on the Help menu, type format numbers in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Modification Type:MinorLast Reviewed:8/18/2005
Keywords:kbbug kbpending KB213901
©2004 Microsoft Corporation. All rights reserved.