kalau DATE-FORMAT pada PC anda (control panel > regional setting) *=
dd/MM/yyyy*
=LEFT(A2,FIND("-",A2))&TEXT(B2,"DDMM")&"-"&TEXT(ROWS($A$2:A2),"000")
kalau DATE-FORMAT pada PC anda (control panel > regional setting) *=
MM/dd/yyyy*
=LEFT(A2,FIND("-",A2))&SUBSTITUTE(LEFT(B2,5),"/","")&"-"&TEXT(ROWS($A$2:A2
),"000")
2011/6/23 Yulius Minsai <[email protected]>
> **
>
> Dear semua,****
>
> Aku punya PR seperti terlampir di bawah, sudah coba berbagai macam pake
> contoh data milis sebelumnya.., tp msh mentok ..
>
> Mohon pencerahannya yaa ..****
>
> ** **
>
> Data : : data tanggal : Output
> penomoran yg diinginkan :****
>
> KTU-SMD : 20/06/2011 : KTU-2006-001****
>
> KTU-BPP : 23/06/2011 : KTU-2306-002****
>
> GDR-PNJ : 23/06/2011 : GDR-2306-003****
>
> STK-PNJ : 26/06/2011 : STK-2606-004***
> *
>
> STK-PNJ : 27/06/2011 : STK-2706-005***
> *
>
> ** **
>
> Salam,****
>
> Yulius****
>
>
>
