Change date format in Pages

Is there a way to mass change dates from mm/dd/yyyy to MMMMMM dd, yyyy such as 2/3/2018 becoming February 3, 2018?

I have reports with dozens or hundreds of entries and would like to automate the change.

Thank you!

Posted on Jan 13, 2023 10:00 AM

Similar questions

Numbers display date as MM/DD/YYYY Hello. I've been trying to change the date format that is displayed in Numbers, but to no avail. I've got region set to Poland, Europe, as always. I've got the date set as DD.MM.YYYY. But despite this, the date is still being presented in MM/DD/YYYY format. How do I change this? I use the latest Ventura system. Unfortunately, trying to change the region and the date and returning to my preferences doesn't fix the date format.
5044 3
Date format change in MacOS Ventura There only two options yyyy-mm-dd and dd/mm/yyyy. In the previous version it was possible to modify the way how you like it to be and for me it is important to have dd.mm.yyyy as in Latvia for sure this is the most common format. Please add at least one more option for Region "Latvia" : dd.mm.yyyy !
1353 1
macOS 14 Sonoma - Numbers date format problem after upgrade After upgrading to Sonoma, the date formats in my expense file (in Numbers) -which I update every month since 20 years- gone haywire! In Turkiye we use DD-MM-YYYY format. In Language&Regions settings, my region is Turkiye and Date format is DD-MM-YYYY. But when I try format a cell in Numbers, choosing Date&time, only options available, now, is MM-DD-YYYY or MM/DD/YY or MM/DD/YYY. There is no DD/MM/YYY/ or alike format available to choose. I created a custom date format and that's OK. But when I try to "format" a series of dates entered as "string", the format does not work. For example: Date strings (in consecutive rows): 12/09/2023 13/09/2023 When I apply my custom date format they become: 09/12/2023 13/09/2023 and when I try make some calculations on them, like Cell1-Cell2 it gives 87 days :))))) Very frustrating because it's not just looks :), I need correct dates to sort my expenses and etc. Any solutions or comments are much appreciated... Thanks
2302 4

1 reply

VikingOSX

Level 10

123,446 points

Jan 13, 2023 11:07 AM in response to TomPeatman

No.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Change date format in Pages

Welcome to Apple Support Community

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

Learn more Sign up