Change Date Format

[worswick25]

Dear Excel Forum,

On the attached Excel spreadsheet SETI.xls … Column B

I need to have all of the Dates in the numeric format mm/dd/yyyy (must be month first)

i.e. instead of Jan 04, 01/04/

Is it possible to have a Multiple Replace Macro for all years ?
-------------------------------------------------------------------------------------------------
Replace Jan, with 01/ ( replacing the Jan and comma with 01 and forward slash )
Replace Feb, with 02/
Replace Mar, with 03/
Replace Apr, with 04/
Replace May, with 05/
Replace Jun, with 06/
Replace Jul, with 07/
Replace Aug, with 08/
Replace Sep, with 09/
Replace Oct, with 10/
Replace Nov, with 11/
Replace Dec, with 12
-------------------------------------------------------------------------------------------------
Would the Macro non case sensitive work with either JAN or Jan or jan

Hoping that you can oblige

Derek