Excel Forum

Problem with reversing dates

lea cohen

Member

Members

Forum Posts: 237

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

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: Susan VanRiper, QSolutions Group

Guest(s) 9

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 880

Purfleet: 414

Frans Visser: 346

David_Ng: 306

lea cohen: 237

Jessica Stewart: 219

A.Maurizio: 213

Aye Mu: 201

jaryszek: 183

Newest Members:

Herbie Key

Trevor Pindling

Stevan Kanjo

Erin Sheldon

Nikita Bhatia

Sheilah Taylor

Clare Webber

David Jenssen

Dominic Brosnahan

Young You

Forum Stats:

Groups: 3

Forums: 24

Topics: 6526

Posts: 28575

Member Stats:

Guest Posters: 49

Members: 32809

Moderators: 2

Admins: 4

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

Moderators: Velouria, Riny van Eekelen

Problem with reversing dates|General Excel Questions & Answers|Excel Forum|My Online Training Hub