dates

Question

how to change American dates to european dates eg for 15 december 2022 I want 15/12/22 but 12/15/22 is appearing

Answer 1

Please never change the system settings, that's bad because it affects ALL application on the WHOLE PC and in many cases causes a lot of trouble.

Use the LCID codes inside the number format to change the output:

Date	Format used:	Description
3/14/1964	m/d/yyyy	System Short Date
Saturday, March 14, 1964	[$-F800]dddd, mmmm dd, yyyy	System Long Date
14.03.1964	[$-407]dd.mm.yyyy	German Short Date
Samstag, 14. März 1964	[$-407]dddd, d. mmmm yyyy	German Long Date
3/14/1964	[$-409]m/d/yyyy	English US Short Date
Saturday, March 14, 1964	[$-409]dddd, mmmm d, yyyy	English US Long Date
14/3/1964	[$-809]d/m/yyyy	English UK Short Date
Saturday, 14/03/1964	[$-809]dddd, dd/mm/yyyy	English UK Long Date

Sample file:
https://www.dropbox.com/s/ziq3kw3gt9egcsr/838835aa-3580-4e85-88bc-1e7466af4895.xlsm?dl=1

Here are the details which codes can be used: https://learn.microsoft.com/en-us/openspecs/windows_protocols/ms-lcid/70feba9f-294e-491e-b6eb-56532684c37f

Okay, that sounds complicated, but there is a simple way to get the correct LCID:

If you format the cell, you can choose a Locale inside the Format window.
And for some languages you can also change the Calendar to be used:

After you make your settings like on Custom and you can see the codes:

Using that way you can show a date for (allmost) all languages on the world!

Andreas.

Answer 2

Before

After

Answer 3

No that instruction didn’t transfer down to excel on desktop

Answer 4

Hi ROLD,

Greetings! Thank you for posting to Microsoft Community.

Change your region setting will change the date format.

Search > region >Format ,Then select a European Country.

Best Regards,

Snow Lu