View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
FARAZ QURESHI FARAZ QURESHI is offline
external usenet poster
 
Posts: 553
Default 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