Changing Date Format

[maverik]

I have dates in two columns which are in different formats. I want to convert them in the format MM/DD/CCYY. When i give this format some dates do get changed but some don't. How to solve this problem.

 

[niceguy_jay]

you will need to attach the excel with both the date formats...only then will someone will be able to find out what exactly the problem is...

 

[Andrew Poulsom]

The dates that don't change are text entries that look like dates. You should be able to convert them to serial dates using Data|Text To Columns and specifying the date format at Step 3 of the Wizard.

 

[maverik]

Thanks for your reply. I have tried it what u suggested but even then some entries don't change to desired format. Please guide.

 

[Andrew Poulsom]

Can you post some sample data please?

 

[maverik]

Here are some of the dates:

04/03/1982
1/1/1969
31/08/1983
10/3/1985
1/1/1957
15/06/1986
18/02/1988
2/2/1960
12/2/1971
6/10/1990
1/1/1972
1/1/1985
10/9/1988

 

[Andrew Poulsom]

All those converted to serial dates when I chose Data|Text To Columns and selected Date DMY at Step 3 of the Wizard.