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.
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.