converting dd/mm/yy to mm/dd/yyyy

[nicolamoore]

I have data in excel which I suspect is in text format and which is dd/mm/yy.
I want to convert it to date format mm/dd/yyyy.
I've done this before successfully, but I don't remember how.
Please help.

 

[Ron Coderre]

Try this:

Select the range of "text dates"

From the Excel Main Menu:
<data><text-to-columns>
....Click: [Next]
....Click: [Next]
....Check: Date....DMY
....Click [Finish]

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

 

[nicolamoore]

Yup.
Solved the problem.
Thanks.

Try this:

Select the range of "text dates"

From the Excel Main Menu:
<data><text-to-columns>
....Click: [Next]
....Click: [Next]
....Check: Date....DMY
....Click [Finish]

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

I have data in excel which I suspect is in text format and which is
dd/mm/yy.
I want to convert it to date format mm/dd/yyyy.
I've done this before successfully, but I don't remember how.
Please help.

 

[Ron Coderre]

You're very welcome.......I'm glad I could help.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

Yup.
Solved the problem.
Thanks.

Try this:

Select the range of "text dates"

From the Excel Main Menu:
<data><text-to-columns>
....Click: [Next]
....Click: [Next]
....Check: Date....DMY
....Click [Finish]

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

I have data in excel which I suspect is in text format and which is
dd/mm/yy.
I want to convert it to date format mm/dd/yyyy.
I've done this before successfully, but I don't remember how.
Please help.