Re: date recognition problem

Tech-Archive recommends: Speed Up your PC by fixing your registry

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" <Chandler@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:821BEFBD-8182-4874-9EC2-E5F7F8C77B9A@xxxxxxxxxxxxxxxx


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 work*** 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

.

Quantcast