| 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 | |||
Hybrid Mode
