F
FARAZ QURESHI
What time format/technique could help in having AM/PM be displayed as am/pm?
Thanx in advance
Thanx in advance
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jarek Kujawa
try:
=LOWER(TEXT(A1,"hh:mm AM/PM"))
=LOWER(TEXT(A1,"hh:mm AM/PM"))
F
FARAZ QURESHI
Thanx Jarek but it is not a formula I require. How to insert it in the Format
Number dialogue Box?
Number dialogue Box?
J
Jacob Skaria
Dear Faraz
Custom format the cells to
hh:mm a/p"m"
If this post helps click Yes
Custom format the cells to
hh:mm a/p"m"
If this post helps click Yes
F
FARAZ QURESHI
XCLent Jacob.
Jacob Skaria said:Dear Faraz
Custom format the cells to
hh:mm a/p"m"
If this post helps click Yes