Hello,

I have data pulled from a text list and the dates are formatted as text, I can change them by doing "text to columns" and then formatting by dd/mm/yyyy, but i was wondering if there is an easier way of doing this via vba, the dates are always in column A.

thanks reg