Microsoft KB Archive/50990

{| = Excel: Custom Format mm:ss Doesn't Display Values as Expected =
 * width="100%"|

Last reviewed: November 30, 1994

Article ID: Q50990

SUMMARY
The characters &quot;mm&quot; in a Microsoft Excel number format can signify either a number of minutes or a two-digit value indicating the number of the month. Any number format containing &quot;mm&quot; returns the two-digit value of the month specified by the serial number contained in the cell, unless it is preceded by &quot;hh:&quot;.

For example, the number format &quot;hh:mm&quot; returns the hours and minutes specified by the serial number contained in the cell (such as, 2:30 PM displays as 2:30).

The number format &quot;hh:mm:ss&quot; returns the hours, minutes, and seconds specified by the serial number contained in the cell (for example, 10 minutes and 30 seconds after noon displays as 12:10:30).

The number format &quot;mm/dd/yy&quot; returns the month, day, and year specified by the serial number contained in the cell (for example, June 12, 1965, displays as 06/12/65).

However, the number format &quot;mm:ss&quot; returns the two-letter month abbreviation, and the number of seconds, represented by the serial number contained in the cell (for example, 4:15:45 [4:15 and 45 seconds] on December 25 would display as 12:45). There is no way to display only the number of minutes and seconds.

This feature is under review and will be considered for inclusion in a future release.

Note: This information is also valid for Microsoft Excel for Windows versions 2.1, 2.1c, and 3.0, and Microsoft Excel for OS/2 versions 2.2, 2.21, and 3.0.
 * }