Hello,
I’m using Excel 2007 and have used replace to change “Positions as of 20-Aug-2014”

TO

“20-Aug-2014”, as the below code;

Worksheets("GS").Range("A3").Replace _
What:="Positions as of", Replacement:="", _
SearchOrder:=xlByColumns, MatchCase:=True

I end up with 20-Aug-2014 and would like to format that as a date, but when I do so the result is the same i.e. 20-Aug-2014 I tried;
Range("A3").Select
Selection.NumberFormat = "m/d/yyyy"

Can anyone suggest VBA code to format this to date format m/d/yyyy?
Thank you