The information in this article applies to:
SYMPTOMSIn Microsoft Excel 98 Macintosh Edition, when you enter a time into a cell, the cell may change to the General number format, and display a decimal number. CAUSEThis 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.25138889" WORKAROUNDTo work around this problem, change the cell to the Time number format. To do this, follow these steps:
STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. MORE INFORMATIONREFERENCESFor more information about formatting, click the Index button in Microsoft Excel Help, type the following text numberand then double-click the selected text. Click to select "Change the way Microsoft Excel displays numbers" and click Go To. Additional query words: XL98
Keywords : xlformat |
Last Reviewed: January 31, 2000 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |