Forum Discussion
Solved
Custom Date Format Question in Excel
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 ...
- 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.
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")
That worked! Thank you very much, but do you also know how to make it all caps?
- 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.