EXCEL: How to present 8-bits binary numbers
 

In Excel: I need to sum 32 bytes, each is 8-bits binary numbers
How do I present an 8-bits binary numbers ?

EXCEL: How to present 8-bits binary numbers
 

One way:

A1: 00100101
B1: =BIN2DEC(A1) === 37



In article ,
HK wrote:

How do I present an 8-bits binary numbers ?

EXCEL: How to present 8-bits binary numbers
 

Conver them to decimal, add them and then convert back to binary using
BIN2DEC and DEC2BIN formulas

If you have binary numbers in Col A, then in Col B use =BIN2DEC(A1)...

See help for 'Convert numbers to different number systems'

"HK" wrote:

In Excel: I need to sum 32 bytes, each is 8-bits binary numbers
How do I present an 8-bits binary numbers ?