Tema: Re: Excel DEC2BIN dideliems skaiciams
Autorius: Linas Petkevičius
Data: 2017-03-28 10:21:52
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).
>