Displaying AM/PM in Lowers

[FARAZ QURESHI]

What time format/technique could help in having AM/PM be displayed as am/pm?

Thanx in advance

 

[Jarek Kujawa]

try:

=LOWER(TEXT(A1,"hh:mm AM/PM"))

 

[FARAZ QURESHI]

Thanx Jarek but it is not a formula I require. How to insert it in the Format
Number dialogue Box?

 

[Jacob Skaria]

Dear Faraz

Custom format the cells to
hh:mm a/p"m"

If this post helps click Yes

 

[FARAZ QURESHI]

XCLent Jacob.

Dear Faraz

Custom format the cells to
hh:mm a/p"m"

If this post helps click Yes