date problem in excel

A

arindamkol_1978

dear all ,

PLS HELP ME SOON . IM FACING A PROBLEM IN DATE FORMAT . I GOT
DATA(500) FORM SYSTEM , THERE THE DATE FORMAT WAS 060606 THAT MEA
(06-JUN-06) . NOW I WANT TO CHANGE THAT FORMAT TO THI
FORMAT(DD-MMM-YY) BY USING 1 FUNCTION OF FORMULA.

ARINDA
 
M

Marcelo

Hi,

try to use it

=date(20&right(a1,2),mid(a1,3,2),left(a1,2))

format as date dd-mmm-yy

hth
regards from Brazil
Marcelo

"arindamkol_1978" escreveu:
 
A

arindamkol_1978

dear all,

thanks for trying this. but it was not warking . it have some error i
i used this
formula [ DATE(20&RIGHT(B2,2),MID(B2,3,2),LEFT(B2,2)) ] and put 06060
then I got the date as 05/12/2065 .
Pls help me .............. , i could not solved it still now.
arinda
 
A

arindamkol_1978

hi,
Im very sorry. 2morrow i send u a mail and told the function was not
working , but at night i solved the problem . the function was correct
I was wrong.Thanks a lot . Bfore 2day i update the date field
1by1.Every day i have 2 update atlist 500 data. Now i doing that only
one function.

I want to friendship with u , if u want then pls mail me in this
e-id([email protected])

Thanks .
 
Top