Tema: Re: Excel DEC2BIN dideliems skaiciams
Autorius: Shadowed
Data: 2017-03-28 11:51:06
Aciu :) !

"kef"  parašė naujienų news:obd3qa$ogp$1@trimpas.omnitel.net...

Liuks, gal pravers

"Linas Petkevičius" <linas@NONONOlekiam.lt> wrote in message
news:obd2ug$nc7$1@trimpas.omnitel.net...
> Kompoiuteriams tokiu dideliu skaiciu niekad nereikes :)
>
> =DEC2BIN(MOD(QUOTIENT($A$1,256^3),256),8)&DEC2BIN(MOD(QUOTIENT($A$1,256^2),256),8)&DEC2BIN(MOD(QUOTIENT($A$1,256^1),256),8)&DEC2BIN(MOD(QUOTIENT($A$1,256^0),256),8)
>
> "kef"  wrote in message news:obd2qs$n6i$1@trimpas.omnitel.net...
>
> ne, iki 32767, nes po to panasu exceliui plaukiancio kablelio mantises 
> bitu
> nepakanka kazkur atvaizdavime, paskutini vieneta suvalgo
>
>
> "kef" <edwardk@takas.lt> wrote in message
> news:obd2ck$mjc$1@trimpas.omnitel.net...
>> iki 65535
>> =DEC2BIN(A1 / 256) * 100000000 + DEC2BIN(MOD(A1,256))
>>
>> tik celes formata reikes pakeisti i num ir panaikinti zenklus po kablelio
>>
>> "Shadowed" <shadowed@bk.ru> wrote in message 
>> news:obd1bp$l8p$1@trimpas.omnitel.net...
>>> Kolegos, pagelbekit, kaip ta kvaila Exelio apribojima paprastai apeiti ? 
>>> Maksimalus konvertuojamas skaicius 511 (DEC), o man reikia 10000 (DEC).
>>