binary bit word
 

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.

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


--
Dnereb
------------------------------------------------------------------------
Dnereb's Profile: http://www.excelforum.com/member.php...o&userid=26182
View this thread: http://www.excelforum.com/showthread...hreadid=397386

"Don" ha scritto nel messaggio
...
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.

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