XL2000: General Number Format Applied to Improper Time Entry

• Microsoft Excel 2000

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 this to be a problem in the Microsoft products 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.

Additional query words: XL2000

Keywords : xlformat
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug