Microsoft KB Archive/210648

{|
 * width="100%"|

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

 * }

-

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.