This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 6%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
If i type 1/11 for 1 Nov it shows 11 Jan. I changed region form uk, newzealand, south Africa all the same. Please help - What region and what setting. Im working on excell online. I tried everything in format date and other. No luck
In Excel online, select the cells the dates will be located in then press Ctrl + 1 to open the formatting Options panel, set Category to Number - Date, then set the country to English UK or English Ireland and apply that, is the date format then set correctly?
HI.
I did all of that. still dont change it.
It changes the date and month around - It is set to d/mm and if i type 1/11 for 1 Nov it shows 11 Jan.
Were do i change the default settings from M/D to what i need - D/M ??
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
If those settings did not resolve the problem, go to your Microsoft account online, then go to 'Your Info' - 'Regional formats' - 'Configure Options' and check your Region and formats set there.