Format-Cells-'Number' Tab-Custom and enter this formula:

[$-409]mmmm d, yyyy h:mm AM/PM;@


--
Regards,
Dave


"Bill R" wrote:

The current date and time pulls but it does not specify am or pm. How can I
write a formula that will show the current time as am or pm?