Converting date formats

[Diana G.]

I have dates that were sent to me in the European format (22-5-2006) and I
need to convert them to the American format (5-22-2006). How can I do this
without changing each one manually? Thx~

 

[Farhad]

Hi,

active the cells that you want to change, right click on the active cells,
choos format cells, choos the tab "Number", choos costom, enter in the type
textbox: mm-dd-yyy or mm/dd/yyy and then click OK

Thanks,

 

[Toppers]

Select column
Data==>Text to Columns
Next,Next
Set Column Data format: Date
Set MDY format from drop down
Finish

 

[Farhad]

sorry you have to enter mm-dd-yyyy or mm/dd/yyyy

Thanks,