I'm using the Numbers calendar template and I want to change the the order of the days of the week so that they begin with Monday instead of Sunday. I can't figure out how to do this without losing the formula that's already built in to put the calendar date numbers on the correct days of the week. I also can't find this in Help. Can anyone explain how to do this?
iMac 27″, macOS 12.6
Hi Lucca,
I assume that you talk about this template
Please select the cell that contains the month.
Then go to the top menu and select "Table > Unhide all Rows" and then "Table > Unhide all Columns"
Now it should look like this
Enter a 2 in cell A3, based on the description on the right
Last step would be to hide rows 3 to 17 and columns C to H and you should be done.
Hope this will solve your question, please let me know if this worked for you or if something in unclear.
Regards Ralf
Hi Lucca,
I assume that you talk about this template
Please select the cell that contains the month.
Then go to the top menu and select "Table > Unhide all Rows" and then "Table > Unhide all Columns"
Now it should look like this
Enter a 2 in cell A3, based on the description on the right
Last step would be to hide rows 3 to 17 and columns C to H and you should be done.
Hope this will solve your question, please let me know if this worked for you or if something in unclear.
Regards Ralf
There is a preference setting for this in the Calendar application, but I did not find it in a brief search of Numbers Preferences or System Preferences.
Resetting your location and language preferences may trigger this change, but again, I've not dug deeply into those.
Regards,
Barry
Ralf, this is SUPER helpful. I never would have figured this out on my own in a million years. Thank you. Now it matches my iCal and I'm less likely to make day-of-the-week mistakes in transferring dates. You're a prince! Lucca
Hi Ralf,
You got it!
Regards,
Ian.
Well done, Ralf!
Regards,
Barry
Editing Numbers Calendar template
