| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Binary Numbers | Excel Discussion (Misc queries) | |||
| decimal to 16 bits binary conversion in Excel? | Excel Worksheet Functions | |||
| Solver returns non binary answer in binary constrained cells | Excel Worksheet Functions | |||
| large binary numbers | Excel Worksheet Functions | |||
| Binary Numbers longer than 10 characters | Excel Worksheet Functions | |||
Hybrid Mode
