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
|