O, suveike, aciu labai!!!!

"random@w" <randomtrinam@randomtrinam.lt> wrote in message 
news:gk72db$ne7$1@trimpas.omnitel.net...
>o tai tau reikia is tekstinio i data paverst ar tik formata pakeist?
> is tekstinio "1978 01 24"
> =DATE(LEFT(A1;4);MID(A1;6;2);RIGHT(A1;2))
> formata pakeist i: "dd/mm/yyyy"
>
>
> ji nori teksta i teksta:
> =TEXT(DATE(LEFT(I11;4);MID(I11;6;2);RIGHT(I11;2));"dd/mm/yyyy")