In Numbers, I've seen how to change the default cell colour and font, based on table styles.

But how can one change the default number formatting? The default "American" formatting for dates, for example, drives me nuts, and it's often the first thing I change in every new spreadsheet I create!

I would like dates to automagically take on YYYY-MM-DD format — especially if I enter them that way! But currently, they revert to DD mon YY format.

1 Answer 1


You do not change it in Numbers.

You change the the system date format from the Language & input system Prefpane. Change the Region to United Kingdom.

Next time you launch Numbers the format will be as you want.

enter image description here

You can use the Custmize buttons to set the look of the dates

enter image description here

  • I already have the short format set how I want it, but Numbers appears to be using the "Medium" format. Indeed, mine looks like your screen shot! So I set "Short" and "Medium" both to YYYY-MM-DD, and now it's working -- thanks! Commented Dec 26, 2012 at 1:43

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .