Question

Locked

HOW TO AUTOMATICALLY CHANGE DATE FORMAT

By joeseeya ·
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

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

excel date

by PurpleSkys In reply to HOW TO AUTOMATICALLY CHAN ...

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

Collapse -

HOW TO AUTOMATICALLY CHANGE DATE FORMAT

by joeseeya In reply to excel date

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

Collapse -

read through here

by PurpleSkys In reply to HOW TO AUTOMATICALLY CHAN ...

see if it helps http://www.computing.net/answers/office/automatic-date-feature-in-excel/7743.html

Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums