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 answer 1111111111111111111111111111111111111111111111111111111111111111111111111111 1111111111111111111111111111111111111111111111111101011011111011010100011111 1001110111100101111001000010000111010110010010100110011010001001100111101010 0001010101001011110011111100 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.
|