How to change date input format Excel

January 1, 2018 at 19:40:28
Specs: Macintosh
Want to enter dates as dd mm but excel recognises as mm dd. Can change display formats OK, but this is input format. Thanks.

message edited by JGH


See More: How to change date input format Excel

Report •

#1
January 1, 2018 at 21:35:06
To change the input format you will need to change the language and region settings of the
operating system and I do not know where they are on a Mac.

Just be aware that by changing the system date settings,
it will affect all of the other programs you have running on your machine,
which could lead to unforeseen problems.

MIKE

http://www.skeptic.com/


Report •

#2
January 1, 2018 at 23:15:53
Thanks Mike,
but I already checked this -and they are correct, i.e., different to the way excel takes the input. They are at System Preference/ Language & Region/Advanced/Date and is set to dd-mmm. There seems to be some problem with excel reading that info... Got me stumped. but thanks for your input.

Report •

#3
January 2, 2018 at 10:14:41

Just to make sure we are on the same page, when you enter:

DD/MM/
06/01/18 

You want January 6th, 
You do not want, June 1st, correct?

Are you in the US or Europe/England?
The MM/DD/YY is the usual American entry style
while the DD/MM/YY is the usual European style.

Make sure you changed all the system dates.
On Windows there is a Long Date & a Short Date.

You could also try a Repair, or just do an Uninstall & Reinstall.

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
January 2, 2018 at 15:39:53
Thanks again Mike,
You are correct - I want Jan 6, not June 1.
I am in Australia, and we use DD/MM/YY. I have changed all the system dates that I can find - or rather, checked them; none needed to be changed.
There is a long & short date option on Mac as well, in fact you can set anything you can think of.
I think the realisation is coming that it's an uninstall and reinstall, as you suggest.
Thanks again for your input.
John

Report •

Ask Question