Date Format Problem

Not sure what you may be doing differently since this is the proper method.

Try running this macro on the sheet where the dates reside. It presumes the data is in the B column starting at cell B2. Adjust the macro to point to the first cell.

Also, you will have to highlight all the date cells before activating the macro:

Sub DateConvert()
    Selection.TextToColumns Destination:=Range("B2"), DataType:=xlDelimited, _
        TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _
        Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
        :=Array(1, 3), TrailingMinusNumbers:=True
End Sub

This does result i n all dates right-flush in the proper format.

Hi !
I've changed the date format to MDY in the last step and it works like a charm ! I thought the last option dealt with the output format but it was the input format (format#1 in the example).
Thanks everyone for the help!

Antony