XL2000: "am/pm" Changed to "AM/PM" in Custom Number Format

ID: Q212114

The information in this article applies to:

Microsoft Excel 2000

SYMPTOMS

If you open a workbook created in a version of Microsoft Excel earlier than Excel 97, and the workbook contains time data, the formatting for time data in cells or in charts may be changed from "am/pm" to "AM/PM." For example, if you create the time "1:00 am" (without the quotation marks) in cell A1, using the earlier version of Excel, and you then open the workbook in Microsoft Excel 2000, cell A1 displays "1:00 AM" (without the quotation marks).

CAUSE

Microsoft Excel 2000 does not support custom number formats in which "AM/PM" is lowercase. For example, the following format is not supported:

h:mm am/pm

RESOLUTION

To display "am/pm" in lowercase, change the number formatting to a format similar to the following:

h:mm a/p"m"

Be sure to include the quotation marks.

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 custom number formats, click Microsoft Excel Help on the Help menu, type "Create a custom number format" in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Additional query words: upper lowercase uppercase revert XL2000

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