Hi

I have some dates like this:Sunday, 10 September 2006
in my worksheet, I've tried to change the format in excel with no luck.

If they can be changed would it be possible to run a macro to change all the
dates in the worksheet in one go.

Thanks in advance.

Dave