• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Custom number format not working

In the attached file, I'm trying to apply custom number format to column F. I want the result to look like column H.

I'm almost there but I can't get the month to be in all caps.
 

Attachments

  • Chandoo.org - Custom Number Format.xlsx
    9.1 KB · Views: 4
You want format date with all CAPS, but you would not using custom number format.

You would need to use an in cell TEXT function to enforce UPPER, e.g. in H2 formula copied down:

=UPPER(TEXT(F2, "d mmm yy"))
 
Back
Top