Try this to see if it works:

highlight the column with the offending dates, click Data |
Text-to-columns then click <Finish on the first panel.

Hope this helps.

Pete

Louise wrote:
Help!

I have a file which I download from an intranet application. For some
reason one of the columns that comes in as a date field, is coming through in
some cells OK and in others as a text format (this is easily identifiable
depending on whether they are justifies to the left or right of the cell).
All the dates are valid (not 30th Feb), and my regional setting are fine too.
What I don't understand is that in all other columns the dates are fine, but
for some reason this one column is a mix and match of date and text and is
causing me problems (i want to import it into access). The only way to get
around this is to manually click in each of the text format cells and hit
enter and they change to date format and are correct, problem is i have over
10,000 lines like this!

Any suggestions appreciated,
Thanks,