Excel 2007 : Date Imported Incorrectly and I need to correct it

[lines_michael]

I have a raw data set and whomever pulled this, accidentally pulled the data into Excel with the wrong date format.

For example the record reads: 2/1/2010 , the format is set to Month/Day/Year but the date is supposed to be 1/2/2010.

How can I create a new column with this corrected? I haven't used macro's or VBA yet. So a formula or function would be great.

[vlady]

-data menu
-text to column
-delimited
-choose date..... option there...

[lines_michael]

Worked Perfect. Thank you. That feature will come in handy in the future.

[vlady]

your welcome