Question Locked

HOW TO AUTOMATICALLY CHANGE DATE FORMAT

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

4 replies

by purpleskys

right click, format cell, number tab, date, choose type of date from the list provided...hope that's what you're looking for

by joeseeya

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

This discussion is closed to new replies.