Custom Date Format Question in Excel

[nurkoandrea]

Hi, 

I'm hoping someone can help me with this. 

I am trying to create a custom date format that would look like "SEPTEMBER 26 @ 11:59 PM". 

By typing in the following formula "[$-en-US]mmmm d h:mm AM/PM;@" I was able to get "September 5 12:00 AM".

When I made the format the time was 8:58 PM not 12:00 AM, so if anyone knows how to insert the @, get the time right, and make it all caps, I would really appreciate it. 

= Andrea

[#2]

@nurkoandrea Try below custom number format.

[$-en-US]mmmm d \@ h:mm AM/PM

Or TEXT() function like

=TEXT(A1,"[$-en-US]mmmm d \@ h:mm AM/PM")

[#3]

That worked! Thank you very much, but do you also know how to make it all caps?

[#4 · Accepted solution]

If it helps then please mark it as solved (tick mark the answer). In case of formula you can try =UPPER(TEXT(A1,"[$-en-US]mmmm d \@ h:mm AM/PM")). I am not sure about custom formatting to make it caps.