Write a macro to modify date formatting

[easbury]

I am having some trouble getting a date in a correct format. I need a macro to change the format. Currently I have an instrument at outputs data into Excel and gives the date in this format: 23.Feb.2011. I need the date to be in MM/DD/YYYY format: 02/23/2011.
This will always start in cell B3 and will need to continue until there are no other entries in the column.

Any suggestions?

 

[AlphaFrog]

Sub Convert_To_Dates()

    Range("B3", Range("B" & Rows.Count).End(xlUp)).Replace ".", " "
    Range("B:B").NumberFormat = "mm/dd/yyyy"

End Sub

 

[easbury]

Works Great! Thanks!

 

[AlphaFrog]

You're welcome.

 

[Rick Rothstein]

You can do this easily without using a macro. Select the column with your "dates" and then click Data/Text To Columns on the menu bar. When the dialog bog appears, click Next twice and then, on that (Step 3) dialog page, look at the set of OptionButtons in the upper right corner... select the Date option and select DMY in the drop-down box next to it, then click the Finish button. Your "date" entries will now be real dates that you can format anyway you want.