| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Himu wrote:
no, for large numbers DEC2BIN functions dont work. Any other suggestions? Sure it does, you just have to work a little harder. =DEC2BIN(INT(n/256),8)&DEC2BIN(MOD(n,256),8) However, 65536 = 2^16, so you need 17 bits to represent it, as in =DEC2BIN(INT(n/256),9)&DEC2BIN(MOD(n,256),8) Jerry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I convert binary numbers to decimal when they are larger . | Excel Worksheet Functions | |||
| Binary Numbers longer than 10 characters | Excel Worksheet Functions | |||
| Working with a large group of numbers | Excel Worksheet Functions | |||
| Excel should be able to compute the MOD of large numbers. | Excel Worksheet Functions | |||
| finding common numbers in large lists | Excel Worksheet Functions | |||
Threaded Mode
