Excel Forum

Problem with reversing dates

lea cohen

Member

Members

Forum Posts: 219

Member Since:
March 10, 2016

Offline

March 20, 2022 - 7:21 am

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

Anders Sehlstedt

Eskilstuna, Sweden

VIP

Members

Trusted Members

Forum Posts: 871

Member Since:
December 7, 2016

Offline

March 21, 2022 - 5:11 am

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

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Sonja Mason, Alexandra Radu, Denise Lloyd

Guest(s) 10

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 871

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

A.Maurizio: 202

Jessica Stewart: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

Raj Mattoo

Mark Luke

terimeri dooriyan

Jack Aston

AndyC

Denise Lloyd

michael serna

mashal sana

Tiffany Kang

Leah Gillmore

Forum Stats:

Groups: 3

Forums: 24

Topics: 6219

Posts: 27276

Member Stats:

Guest Posters: 49

Members: 31903

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen