Hi! Experts

In column A i have Dates with different Format.

Like

Dates
28/08/09
05-09-2009
8.27.2009
8.27.2009
8.27.2009
8.29.2009
25/08/09
25th Aug
31.08.09
2nd sep
2nd sep
4th Sep


Now i want to Change this Dates of MM-DD-YYYY FORMAT.

When i change the Whole Columnn i.e. Column A into mm--MM-DD-YYYY FORMAT.
Some Cell Apply this format some not.

Is it Possible to Change the Whole Column in a Once.

Or I have to go Manually. Column A has 1500 data.

Thanks in Advance

Hardeep kanwar

Hi there
After the whole column date format which dates are still not changed?

I guess it is the
8.27.2009
8.27.2009
8.27.2009
8.29.2009
if yes
Do the whole column date format first. then EDIT from FIND/REPLACE "." with
"/" in this column and do the date format again. (You get the idea I hope)



"Hardeep Kanwar" wrote in message
...
Hi! Experts

In column A i have Dates with different Format.

Like

Dates
28/08/09
05-09-2009
8.27.2009
8.27.2009
8.27.2009
8.29.2009
25/08/09
25th Aug
31.08.09
2nd sep
2nd sep
4th Sep


Now i want to Change this Dates of MM-DD-YYYY FORMAT.

When i change the Whole Columnn i.e. Column A into mm--MM-DD-YYYY FORMAT.
Some Cell Apply this format some not.

Is it Possible to Change the Whole Column in a Once.

Or I have to go Manually. Column A has 1500 data.

Thanks in Advance

Hardeep kanwar

Thanks for the Reply

But its not Working

i think the Main Problem is Many dates are manually Entered but in wrong
Format.

Like if today is 09-16-2009 (mm-dd-yyyy) Format.

But the Guys Entered 16.09.09 or 16/9/2009 or 09/16/09

I think it is Possible with UDF OR MACROS

Thanks in Advance



"QuickLearner" wrote:


Hi there
After the whole column date format which dates are still not changed?

I guess it is the
8.27.2009
8.27.2009
8.27.2009
8.29.2009
if yes
Do the whole column date format first. then EDIT from FIND/REPLACE "." with
"/" in this column and do the date format again. (You get the idea I hope)



"Hardeep Kanwar" wrote in message
...
Hi! Experts

In column A i have Dates with different Format.

Like

Dates
28/08/09
05-09-2009
8.27.2009
8.27.2009
8.27.2009
8.29.2009
25/08/09
25th Aug
31.08.09
2nd sep
2nd sep
4th Sep


Now i want to Change this Dates of MM-DD-YYYY FORMAT.

When i change the Whole Columnn i.e. Column A into mm--MM-DD-YYYY FORMAT.
Some Cell Apply this format some not.

Is it Possible to Change the Whole Column in a Once.

Or I have to go Manually. Column A has 1500 data.

Thanks in Advance

Hardeep kanwar