Level 1

3 points

Change date format in Numbers

Hi there,

Please can you help ? I want to change the date format in Numbers , to UK style - DD/MM/YYYY. Have tried all sort so of things to no avail.

Thanks

Jules

Mac Book Pro, Mac OS X (10.4.10)

Posted on May 14, 2013 7:56 AM

Top-ranking reply

cameron.s.hill1

Level 1

10 points

Posted on Dec 22, 2015 12:59 PM

Hey,

As a massive excel user at work I assumed this would be aligned with the system settings as well - turns out not so much.

I've just created a custom date format, whereby I make the date appear like it *should* (yes, read into that what you will incorrect Americans).

All you do is;

select a/all cells you want to hold a date
click on the 'Cell' tab of the format side bar
Drop Down Menu under 'data format' - change to Custom Format
Amend order so day is first, month is second, year is third with '/' between them, click ok

Done. Dates will appear like they should.

View in context

22 replies

lflfm

Level 1

4 points

Aug 4, 2017 1:57 AM in response to cameron.s.hill1

Awesome, this resolves the way the dates look; but I still have to type them in US format! I *really* don't want to have to type 7/31 to get a proper date, this doesn't make any sense to me.

My system preferences are set to custom German... (I prefer the UK format with / than the German format with .)

SGIII

Level 8

37,550 points

Aug 4, 2017 6:22 AM in response to lflfm

lflfm wrote:

I *really* don't want to have to type 7/31 to get a proper date

Then go to File > Advanced > Language & Region ... and pick a Region that suits your needs.

This is an old thread, and Numbers has since moved on.

Dec 4, 2013 12:32 PM in response to Jules2710

I posted a workaround in another thread: https://discussions.apple.com/thread/5546012?answerId=24016942022#24016942022

jaxjason

Level 5

5,063 points

May 14, 2013 8:17 AM in response to Jules2710

What is your locale setting on the machine? I think this is what is used as the default for setting date format.

Jason

Jan 28, 2015 3:23 AM in response to Csound1

It works for me as it displays the uk date. do you have a better suggestion?????

Csound1

Level 9

60,063 points

Jan 28, 2015 3:27 AM in response to RAYtheMAN

If you prefer something to look right but be wrong more power to you.

Try subtracting 3 days from it.

Csound1

Level 9

60,063 points

Jan 28, 2015 3:35 AM in response to RAYtheMAN

If you had read this thread you would know my answer already.

Don't use Numbers, use something else, anything else.

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 Numbers