Thanks both Andy and Richard, I've noted the suggestions and will play around with them.

The other problem, and I guess it's not an Excel problem per se, is why the file which originates from the Quick Books system should have a mixture of US & UK dates all within the same column. I don't kniw Quick Books and have no control over the parameterising of any exported data, so will have to cater for the inconsistencies in VBA.

Regards