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(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Deal All,
I am from Greece so my Windows are in Greek format so and Microsoft 365.
In Excel the days and months appears in Greek.
I want to have the option to have days and months in United States (English).
Can you please help me how to do that?
Thank you very much!!
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Sure, A1 contains a date, B1: =A1, C1: =A1
The whole trick is to format the cell and use a language identifier. Same sample file.
That way you can format any date all around the world. BTW, the same works for the month names.
Any further questions?
Andreas.
The arguments of the TEXT function does not work with other languages, do not use it, in 99% of all cases there is no need.
You said you changed the locale, that's the worst you can do! Reset the settings to your country as described here:
System settings - How to import a CSV file that does not match your - Microsoft Community
"2025-04-01" is not a valid date in Greek, the 1st of April 2025 should be 01/04/2025
If you imported the date or opened a file, this is not a date it's a text. Here's how to import such data correctly:
Power Query - How to import a CSV file that does not match your locale - Microsoft Community
Make a new file, write 1/4/2025 into A1
All this cells contains the same date, just the number format is different for each.
The Short date is the first format of the Date formats, this date will be different on your system, because that changes due to your region settings. Same for the Long date format, which is the second format. In the screenshot above you see a German date, because of my system.
All other formats have language identifier in front and stays as they are.
If you need further help I need to see your (sample) file.
Why a sample file is important for troubleshooting. How to do it. - Microsoft Community
The article also contains a link to a macro that you can use to anonymize your data.
Andreas.
Dear Andreas Killer,
I've tried the solution you suggest me but unfortunately it didn't worked.
Has to do that Windows 11 region is Greece/Greek?
In the C10 cell till C39 cell I have dates.
For example:
C10 cell has 2025-04-01 (I've already changed locale in English (United States).
In the cell D10 I have the formula:
=UPPER(TEXT(C10;"HHHH"))
It returns the day of the week.
For example it's TUESDAY in Greek.
TRITI in Greek.
The HHHH in the formula it's not the English letter H but the Greek letter H.
I want instead of return TRITI to return TUESDAY.
I can't do it!!!
I've tried everything!!
Please help me!!
Format the cells with a date using a language identifier.
[$-en-US]mm/dd/yyyy https://support.microsoft.com/en-us/office/format-a-date-the-way-you-want-in-excel-8e10019e-d5d8-47a1-ba95-db95123d273e
Andreas.
You can use the new TRANSLATE function:
=TRANSLATE("Ιανουάριος","el","en")
will return "January" - the source 'text' can also be from a function rather than a string:
=TRANSLATE(TEXT(TODAY(),"mmmm"),"el","en")
Of course, those functions may be in Greek :)