Is there any way I can take the custom date format "dddd dd mmmm yyyy" and
use it as a compulsory date format (i.e so it will be an option it the 'date'
option in format cells, as opposed to a 'custom' option).

The reason why I am asking is the I have a process where I download a table
(coded in HTML) into excel, using the Workbooks.Open Filename command and
one of the rows in the table will have a date inserted in the format "dddd
dd mmmm yyyy". The trouble is that excel does not recognise this a date when
the page is downloaded into excel.

I have tried various ways to get around this but to no avail.

Can anyone help?

Bhupinder Rayat