Hi there,

If you were to go to Control Panel and select Regional and Language Options then select English (United States) as Region. This will cause excel to read US format dates, then it can simply be changed back again.

I appreciate your help.

Thanks,

Marshybid