Charlietbh,

Your code will alter the format for a date in number form. I suspect your stubborn dates are text?

If so you can easily convert them by selecting >> Data tab >> Text to columns >> Next Next Finish

Then run your code if you need.

Hope that helps.