i recently export some data to excel, which give me the date format as text,
example:
20060515

how can i convert it to dd/mm/yy format in excel?

please help.

Hi
Select your 'dates' and go to Data>Text to Columns. On the third (I think)
dialog box there is an option in the top right for you to tell Excel that
these are dates - and the format (YYMMDD). Select this and Finish. Make sure
you backup your data before you start!

Andy.

"Max gegaoff" <Max (E-Mail Removed)> wrote in message
news:B6E7167D-E594-4CCA-955B-(E-Mail Removed)...
>i recently export some data to excel, which give me the date format as
>text,
> example:
> 20060515
>
> how can i convert it to dd/mm/yy format in excel?
>
> please help.

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

HTH
--
AP

"Max gegaoff" <Max (E-Mail Removed)> a écrit dans le
message de news: B6E7167D-E594-4CCA-955B-(E-Mail Removed)...
>i recently export some data to excel, which give me the date format as
>text,
> example:
> 20060515
>
> how can i convert it to dd/mm/yy format in excel?
>
> please help.

one way
=DATE(LEFT(D12,4),MID(D12,5,2),RIGHT(D12,2))

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Max gegaoff" <Max (E-Mail Removed)> wrote in message
news:B6E7167D-E594-4CCA-955B-(E-Mail Removed)...
>i recently export some data to excel, which give me the date format as
>text,
> example:
> 20060515
>
> how can i convert it to dd/mm/yy format in excel?
>
> please help.

i not sure how to rate your answer, but thanks a lot.
many thanks.

"Andy" wrote:

> Hi
> Select your 'dates' and go to Data>Text to Columns. On the third (I think)
> dialog box there is an option in the top right for you to tell Excel that
> these are dates - and the format (YYMMDD). Select this and Finish. Make sure
> you backup your data before you start!
>
> Andy.
>
> "Max gegaoff" <Max (E-Mail Removed)> wrote in message
> news:B6E7167D-E594-4CCA-955B-(E-Mail Removed)...
> >i recently export some data to excel, which give me the date format as
> >text,
> > example:
> > 20060515
> >
> > how can i convert it to dd/mm/yy format in excel?
> >
> > please help.
>
>
>

Max

It is the easiest and quickest way to do the job - without helper cells. I
use it all the time. Why are you not sure how to rate it?

Andy.

"Max gegaoff" <(E-Mail Removed)> wrote in message
news:0F6E33BC-3FBC-4CDC-98E0-(E-Mail Removed)...
>i not sure how to rate your answer, but thanks a lot.
> many thanks.
>
> "Andy" wrote:
>
>> Hi
>> Select your 'dates' and go to Data>Text to Columns. On the third (I
>> think)
>> dialog box there is an option in the top right for you to tell Excel that
>> these are dates - and the format (YYMMDD). Select this and Finish. Make
>> sure
>> you backup your data before you start!
>>
>> Andy.
>>
>> "Max gegaoff" <Max (E-Mail Removed)> wrote in message
>> news:B6E7167D-E594-4CCA-955B-(E-Mail Removed)...
>> >i recently export some data to excel, which give me the date format as
>> >text,
>> > example:
>> > 20060515
>> >
>> > how can i convert it to dd/mm/yy format in excel?
>> >
>> > please help.
>>
>>
>>