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.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I wanna make a calendar using the calendar template available in Numbers, but it insists on starting the week with a Sunday. Can I change that somehow?
I've already setup Monday to start the week in the general settings and in the Calendar app settings but that doesn't do much in Numbers.
MacBook Air (13-inch Mid 2013)
What works here is this (assuming you are using the template for Numbers 3):
Add a column at the right by clicking the symbol by the arrow in this screenshot:
The dates in the new column will fill in automatically. Type SUNDAY in the header of the new column.
Then hide (don't delete) the original SUNDAY column on the left.
That's it!
The steps are similar for the little calendars upper right, except that to hide the original Sunday columns there you need to first unmerge the cells in the header of each of those tables (select the header and choose 'Unmerge Cells' from the Table menu). After unmerging, drag the formula in A1 over one cell to the right and then hide column A. And finally select the cells in the header and merge again.
A lot of the math for the calendar, if you're curious, is in hidden rows and columns in the table on the upper left that displays the date and year. Unless you are a lot better at calendar math than I am, best not to mess with it, though.🙂
SG
THANK YOU SO MUCH FOR THIS FIX! <3 <3
Glad it helped. There is much to discover under the surface in the templates included with Numbers. They are well worth studying.
SG
Calender template in Numbers, start the week with Monday
