HOW TO AUTOMATICALLY CHANGE DATE FORMAT
I HAVE DATA SHEET THAT GIVES THE DATE AS FOLLOWS: 6/23/2010.
MONTH/DATE/YEAR
I WANT TO CHANGE THE DATE TO 23/6/2010 [DATE/MONTH/YEAR]TO ENTER INTO MY SPREADSHEET.
HOW DO I DO THIS.
THANKS
JOE
Software
I HAVE DATA SHEET THAT GIVES THE DATE AS FOLLOWS: 6/23/2010.
MONTH/DATE/YEAR
I WANT TO CHANGE THE DATE TO 23/6/2010 [DATE/MONTH/YEAR]TO ENTER INTO MY SPREADSHEET.
HOW DO I DO THIS.
THANKS
JOE
by joeseeya Accepted solution
by purpleskys Accepted solution
by joeseeya Accepted solution
Thankyou for the reply.
The method did not work.
The data I get has the dates with the month/date/year and there are over 1000 rows.
Below [FROM] is the format in the data and [TO] is what I need to convert to.
Hope you will have an answer for me.
FROM
06/09/2010
06/02/2010
05/26/10
05/19/10
05/12/2010
TO
09/06/2010
02/06/2010
26/05/2010
19/05/2010
12/05/2010
Thanking you
joe perera
by purpleskys Accepted solution
This discussion is closed to new replies.
Sort by Trending