General number format applied to improper time entry in Excel for Mac

Article translations Article translations
Article ID: 178460 - View products that this article applies to.
This article was previously published under Q178460
Expand all | Collapse all

On This Page

SYMPTOMS

In Microsoft Excel for Mac, 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.25138889"

WORKAROUND

To work around this problem, change the cell to the Time number format. To do this, follow these steps:
  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.
Note: The numbers will be converted to a proper time value. For example, if you typed 5:62 and then changed the number format; the value of 6:02 will show in the cell.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

REFERENCES

Excel X and later versions

For more information about formatting, click Excel Help on the Help menu, type number formats, click Search, and then click a topic to view it.

Excel 2001

For more information about formatting, click the Office Assistant, type Excel displays numbers, click Search, and then click a topic to view it.

Note If the Office Assistant is hidden, click Office Assistant on the standard toolbar.

Excel 98

For more information about formatting, click the Office Assistant, type Excel displays numbers, click Search, and then click Change the way Microsoft Excel displays numbers to view the topic.

Note If the Office Assistant is hidden, click Office Assistant on the standard toolbar.

Properties

Article ID: 178460 - Last Review: October 6, 2011 - Revision: 3.0
APPLIES TO
  • Microsoft Excel 2004 for Mac
  • Microsoft Excel X for Mac
  • Microsoft Excel 2001 for Mac
  • Microsoft Excel 98 for Macintosh
Keywords: 
kbbug KB178460

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com