Custom number format not working

[DashboardNovice]

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.

 

[bosco_yip]

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"))