Displaying AM/PM in Lowers
 

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

Thanx in advance

Displaying AM/PM in Lowers
 

try:

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



On 27 Maj, 07:41, FARAZ QURESHI
wrote:
What time format/technique could help in having AM/PM be displayed as am/pm?

Thanx in advance

Displaying AM/PM in Lowers
 

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

"Jarek Kujawa" wrote:

try:

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



On 27 Maj, 07:41, FARAZ QURESHI
wrote:
What time format/technique could help in having AM/PM be displayed as am/pm?

Thanx in advance

Displaying AM/PM in Lowers
 

Dear Faraz

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

If this post helps click Yes
---------------
Jacob Skaria


"FARAZ QURESHI" wrote:

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

Thanx in advance

Displaying AM/PM in Lowers
 

XCLent Jacob.

"Jacob Skaria" wrote:

Dear Faraz

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

If this post helps click Yes
---------------
Jacob Skaria


"FARAZ QURESHI" wrote:

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

Thanx in advance