binary bit word

D

Don

Can the 10 bit limit on a binary word be changed to a 15 bit word? I need to
convert a decimal to binary but my decimal number can be as high as 65535 and
because I'm limited to only 10 charactors I can't use this function.
 
D

Dnereb

to my knowledge you need 16 bits to express 65535

But if you need to express this within 10 characters 1111111111111111
just won't fit you could use Hexadecimal &FFFF
 
I

ivano

Don said:
Can the 10 bit limit on a binary word be changed to a 15 bit word? I need to
convert a decimal to binary but my decimal number can be as high as 65535 and
because I'm limited to only 10 charactors I can't use this function.
Click to expand...

hy,
use this array formulas [confirm with ctrl+shift+enter]
=SUM(((0&REPT("8",ROW(INDIRECT("1:"&INT(LOG(H1,2)+1)))-1))+1)*ROUND($H$1/(2^
ROW(INDIRECT("1:"&INT(LOG(H1,2)+1)))),0))
In H1 your decimal number to traslate into bynary.
ivano
 
Top