Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

MacOS Numbers 6.0 (6194) - Custom Date Format - Three Letter Month And ALL CAPS

I am using "MacOS Numbers 6.0 (6194)"


And I have a column that I would like to have the format DD MMM YY were DD is the day of the month and MMM is the (abbreviation in ALL CAPS) of the month of the year and YY is the year of the century.




I am using US English


All I can manage to get is DD Mmm YY where DD is a two digit day of the month with leading 0, and YY is a two digit year of the century.


BUT


Mmm is a a three character abbreviation of the month of the year but I


CAN NOT GET IT TO BE ALL CAPS


This may be impossible but if not I would like to know how to do it.


MacBook Pro 13", macOS 10.14

Posted on Apr 27, 2019 8:56 AM

Reply
Question marked as Best answer

Hi,


Once you've set up your DD Mmm YY, click once on the cell, pull down the Format menu and choose Font ▶︎ Capitalisation ▶︎ All Caps




Hope this helps,


H

Posted on Apr 27, 2019 11:09 AM

Similar questions

3 replies

MacOS Numbers 6.0 (6194) - Custom Date Format - Three Letter Month And ALL CAPS

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.