I am a supporter ofSt. Joseph's hospice. If you find this site useful or if it helped you, consider a small donation toSt. Joseph's, please. Information onSt. Joseph's
 What is the binary representation (with bitlength = 256) of the decimal number -872362346234627834628734627834627834628? Don't ask Excel's built-in function dec2bin(). It cannot handle numbers greater than 511.If you want to get the correct answer1111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111110101101111101101010001111110011101111001011110010000100001110101100100101001100110100010011001111010100001010101001011110011111100 then have a look at the functions listed below. I intend to enhance the functionality. So far fractional parts are possible only for positive decimals which will be transformed into binaries by sbLongDec2Bin(). The decimal 0.5 is in binary format equal to 0.1, for example.
 Function Parameter 1 Parameter 2 Result Comment sbbinneg 0 0 sbbinneg 1 11111111111111111111111111111111 Implicite bitlength is 32 sbbinneg 11111111111111111111111111111111 1 sbbinneg 10000000000000000000000000000000 #VALUE! Correct error value sbbinneg 0 2 0 sbbinneg 1 2 11 sbbinneg 11 2 1 sbbinneg 10 2 #VALUE! Correct error value sbdivby2 0 TRUE 0 sbdivby2 2 TRUE 1 sbdivby2 1024 TRUE 512 sbdivby2 3.14159265 FALSE 1.570796325 sbdivby2 0.5 FALSE 0.25 sbdivby2 0.25 FALSE 0.125 sbdivby2 0.125 FALSE 0.0625 sbdecadd 0 0 0 sbdecadd 0.0001 0.9999 1 sbdecadd 123.456 987.654 1111.11 sblongdec2bin 2005 11111010101 sblongdec2bin 2005 11 #VALUE! Now 2005 is too big sblongdec2bin 11.5 1011.1 sblongdec2bin 2.25 10.01 sblongbin2dec 1111 15 sblongbin2dec 1111 4 -1 longbin2dec 11.11 3.75