Forum

Notifications
Clear all

Problem with reversing dates

2 Posts
2 Users
0 Reactions
69 Views
(@usb)
Posts: 244
Honorable Member
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
Anders Sehlstedt
(@sehlsan)
Posts: 972
Prominent Member
 

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
Share: