kai masinoj pelenine uzispildo perki nauja masina?


Igaliotinis wrote:
> arba regionale winduose pasikeist datos formata
> 
> "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")
>>
>> juk wrote:
>>> Sveiki, gal galite paraðyti, kokià formulæ naudoti MS Excel'yje norint 
>>> pakeisti datos formatà pvz. ið 1978 01 24 á 24/01/1978. 
> 
>