Hi,
I have an excel web query that is pulling off a table into Excel. Column A is basically a list of names and column B is the relevant date. The dates are listed on the website as 01.01.2011 format and are subsequently imported into Excel this way. As a result, I cannot sort column B by date value as Excel is not recognising the format. I’ve tried changing the properties of the date, using find & replace to change it to 01/01/2011 format then changing properties all to no avail.
Ideally I’d just like some sort of Macro/vba code to change the 01.01.2011 into 01/01/2011 format so that I can sort the column.
Can anyone help me with this please?
Bookmarks