Thanks to all. Very helpful

Chandler

"Ragdyer" wrote:

TTC (Text To Columns) should convert that data to XL recognizable dates
quite easily, just by opening and closing TTC.

Select the column of imported dates, then click:
<Data <Text To Columns <Finish

And you should now have a column of XL "legal" dates.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Chandler" wrote in message
...


Hi.
My problem is that I import a table with a number of columns (using "New
web
query"), one of which (D) is a column of dates in the form "08 July 2007"
(two spaces between the number and month as it happens). In Import
External
Data - Options I am forced to select Disable Date Recognition due to the
content of another of the columns which is misread otherwise. Once the
table
is imported into the worksheet I need to get Excel (2003) to recognise the
date column (i.e. D) as dates, which it refuses to do even if I select the
column and Format - Cells... - Date it, or correct the two spaces into the
next column using

=LEFT(D1,2)&RIGHT(D1,LEN(D1)-3)

and then formatting that column using Format - Cell - Date.

Excel will recognise the individual D cells as dates if I click the cursor
in each one first but this is not a feasible solution since the column of
dates is very long.

I'd be grateful if anyone knows a solution. My suspicion is that there
isn't one.

Regards

Chandler