You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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

Categories Month formatting

I have a date column and have turned on categories and sorting by year-month. It groups them nicely as you can see in the photo



My question is, is it possible to change the month label? When I select the cell and go to cell data format I see this



Nothing I change it to sticks. I tried to change it to month only, I tried number month only, I even created a custom type that uses the Japanese formatting 1月23年 but all formatting resets to the January 2023 formatting when I click off and back on the cell.


The other category cells can be formatted in a style of my own choice, so I assumed the date category cell could be as well. But so far it doesn't seem like it.


This isn't a major issue, but it would be nice if I could. I'd like to get rid of the year (seems pointless when I am also using the year category, as you can see in photo 1) and shorten the month to 3 letters. Like in this photo



If anyone knows any way to do this, thank you!

MacBook Pro 14″, macOS 13.1

Posted on Jan 15, 2023 4:15 PM

Reply
Question marked as Top-ranking reply

Posted on Jan 15, 2023 4:36 PM

The category you are using is "year-month" so it's gonna have both I guess. Change the category to "value" and you should be able to format as month only. The built-in date format for month-only is the full name. You will have to create and use a custom format to get the 3-letter month names.

1 reply
Question marked as Top-ranking reply

Jan 15, 2023 4:36 PM in response to dbooster

The category you are using is "year-month" so it's gonna have both I guess. Change the category to "value" and you should be able to format as month only. The built-in date format for month-only is the full name. You will have to create and use a custom format to get the 3-letter month names.

Categories Month formatting

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