Need VBA to change date format in text of entire column

[skyport]

I have text in column A spread out over as much as a few hundred cells. The data contains normal sentences and paragraphs along with occasional dates which will show up in any one of four different formats in general being: M/D/YY, MM/DD/YY, M/D/YYYY and MM,DD,YYYY. What I need to be able to do is be able to run a code from a module that will allow me to choose which date format I want to use that particular day and change all dates that show up in column A to that one selected date format. I am not able to do this by simply formatting the cells because the source data comes from a word document with its own formatting that seems to prevent any Excel date formatting under the normal process I believe. Can anyone suggest a code that would do this?

 

[Peter_SSs]

You are absolutely right. I made the goof in post 1 with the commas. made your recommended adjustments and it works perfectly!! Thanks as always for the marvelous solution.

You are welcome.