Change Text to Date using VBA

[hpope]

Hello there!

I need to automate a process to change text in columns (e.g. 05 Sep 2012) to a date value. I have another macro that searches for future dates and deletes them, but as the dates are currently in the spreadsheet as text (and no way that I can get the source data differently) I must convert them first!

Thank you in advance for any help...

H

[mtt23]

what sort of date value/format do you want?

This code will change it to dd/mm/yy format:

Selection.NumberFormat = "dd/mm/yy;@"