EXCEL: How to present 8-bits binary numbers

H

HK

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

Sheeloo

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'
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Leading zeros 9
Binary Numbers 9
Convert Decimal fractions to binary and vice versa 1
Help needed on generating sequences 3
Format cells for hexadecimal numbers 2
Hex to Binary Conversion 3
what does error message "too many adjustable cells" mean in solver 1
Encoding 8-bit data into 7-bit streams 4

Top