Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying AM/PM in Lowers
What time format/technique could help in having AM/PM be displayed as am/pm?
Thanx in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
displaying changes | Excel Worksheet Functions | |||
Displaying a zero | Excel Discussion (Misc queries) | |||
Not displaying a value | Excel Discussion (Misc queries) | |||
Displaying a different value | Excel Discussion (Misc queries) | |||
Displaying #N/A as a zero | Excel Worksheet Functions |