D DashboardNovice Member Oct 6, 2023 #1 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
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.
B bosco_yip Excel Ninja Oct 7, 2023 #2 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"))
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"))