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

Protecting Word 2019 document 0
Dates In Excel 5
Binary Numbers 9
Remove numbers from brackets 0
How to count the numbers in a Word document? 0
Paragraph numbering in Word 1
Leading zeros 9
How can the font and size of (all) citation numbers be altered? 1

Top