Ask Different is a question and answer site for power users of Apple hardware and software. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
up vote 2 down vote accepted

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

share|improve this answer
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! – Jan Steinman Dec 26 '12 at 1:43

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.