XL2000: Custom Number Formats Using Lowercase AM/PM Appear Uppercase

ID: Q210648

The information in this article applies to:

Microsoft Excel 2000

SYMPTOMS

When you apply a custom time format using lowercase am or pm, the time format reverts to uppercase AM or PM.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

You can apply a custom time format to cells on a worksheet using the Format Cells dialog box (on the Format menu, click Cells). In earlier versions of Excel, you can display lowercase am/pm by using a custom number format similar to the following:

h:mm am/pm

For example, in Microsoft Excel 97, the custom time format h:mm am/pm allows the time 8:30 A.M. to appear as lowercase, 8:30 am. However, in Microsoft Excel 2000, this same custom format appears as uppercase, 8:30 AM.

REFERENCES

For more information about time 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: xl2000 post meridian ante

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