thanks "Joint_as" <a@a.com> wrote in message news:iapgmo$lq3$1@trimpas.omnitel.net... > formule: > =IF(LEFT(A1;1)="3";19;IF(LEFT(A1;1)="4";19;IF(LEFT(A1;1)="5";20;IF(LEFT(A1;1)="6";20;"Blogas > a/k"))))&MID(A1;2;2)&"-"&MID(A1;4;2)&"-"&MID(A1;6;2) > > :) > > > "BlackLotus" <besagun@gmail.com> wrote in message > news:iap92v$edf$1@trimpas.omnitel.net... >> Sveiki, >> kazkada zinojau formule kaip paversti asmens koda i gimimo data gal kas >> galetu priminti Exel 2003 >> Aciu >> >> >> > >