Need the last 16 digits of a binary number so that I can convert it to decimal

[Silverbackman]

Hi all. First time posting.
If this was answered somewhere else, please point me in that direction.

I have to convert decimal numbers to binary, then take the last 16 digits of that binary number and convert them back to decimal.
For example
1701527 is [TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]110011111011010010111[/TD]
[/TR]
</tbody>[/TABLE]

I need the last 16 digits
111011010010111

Which I then convert back to digital and get
63127

What i'd like to do is put the first number into one cell and then in another cell see the final result

Is this possible?

I have tried =RIGHT and =RIGHT+0, but the first gives me a text version and the second when I use it with BIN2DEC comes back with #NUM

Jeff.

 

[mikerickson]

The whole decimal>binary>last16>decimal process could be done with

=MOD(A1, 2^16)

 

[Gilliam]

So BIN2DEC and DEC2BIN only work with 8 bit binary numbers. I think that's -512(-511) to +511(+512). Since your decimal number is quite larger than this, you'll need to string together the binary digits.
to get the last 16 binary digits of a number use this formula:
=RIGHT(DEC2BIN((MOD(A1,4294967296)/16777216),8) & DEC2BIN(MOD(A1,16777216)/65536,8) & DEC2BIN(MOD(A1,65536)/256,8) & DEC2BIN(MOD(A1,256),8),16)
The above formula works for a 32 bit binary number (approx 2.15 billion)
and then the following formula should return the number corresponding to the 16 bit binary number returned from the equation above
=BIN2DEC(RIGHT(B1,8))+256*BIN2DEC(LEFT(B1,8))
Hope that helps,
Matt

 

[Silverbackman]

Matt and Mike...you guys ROCK!!!
Both solutions work perfectly.

Thanks so very much,
Jeff