Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
69
Views
Topic starter
I am in Israel, my excel is set to English.
I type 19/3/22 and it automatically sets me 3/19/22
And that's a problem for me
How can this be arranged? Thanks
Posted : 20/03/2022 5:21 pm
Hello Lea,
Here is an article that gives some help about this topic.
As per standard Excel uses the date and time format set in the operating system, so either change the setting or create a custom date format in Excel, examples are in the linked article.
If you create a custom date format in Excel and the file is to be used by others in a country with a different date format, do inform in the workbook about the date format used.
Br,
Anders
Posted : 21/03/2022 3:11 pm