
lea cohen
Member
Members

Forum Posts: 237
Member Since:
March 10, 2016
March 10, 2016

Hi, thanks for the help with the attachment -
Column B has dates of 2 types - one in Hebrew format and one in English format
How do you change the English format to the Hebrew format? Will there be a match with the data in column C??

Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members

Trusted Members
Moderators

Trusted Members
Moderators

Forum Posts: 614
Member Since:
January 31, 2022
January 31, 2022

I imported to the CSV file (legacy text wizard) and indicated that the second column contained dates in the MDY format and the third in the DMY format. That transformed both columns into valid dates as seen in the attached files.
Important that you don't just open the CSV file in Excel. Then Excel will do some guessing as to how to interpret texts that look like dates.
Is that what you had in mind?

Answers Post
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Mynda Treacy, Bryan Barnett, Lorna Henning
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
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
Hans Hallebeek: 185
Newest Members:
Appiagyei Kofi Frimpong
Hilary Burchfield
Richie Wright
Adel Kock
Barbara Murray
Doug Milne
Siobhan Stringer
Rob Rooth
Tom Lewis
Jennifer Rodriguez-Avila
Forum Stats:
Groups: 3
Forums: 24
Topics: 6542
Posts: 28641
Member Stats:
Guest Posters: 49
Members: 32829
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —
