Home |
Search |
Today's Posts |
#1
|
|||
|
|||
large binary numbers
i want a column which will contain numbers from 0~65536. Then I want to
convert them into 16 bit binary numbers. How do I do this? |
#2
|
|||
|
|||
Will the DEC2BIN function get you what you want?
"Himu" wrote in message ... i want a column which will contain numbers from 0~65536. Then I want to convert them into 16 bit binary numbers. How do I do this? |
#3
|
|||
|
|||
no, for large numbers DEC2BIN functions dont work. Any other suggestions?
"Barb Reinhardt" wrote: Will the DEC2BIN function get you what you want? "Himu" wrote in message ... i want a column which will contain numbers from 0~65536. Then I want to convert them into 16 bit binary numbers. How do I do this? |
#4
|
|||
|
|||
A Google search for "algorithm for converting decimal to binary" yielded several pages with descriptions of a couple of generic algorithms for converting decimal numbers to binary numbers. I'm sure those algorithms could be adapted to a spreadsheet or VBA procedure. -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=389266 |
#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 |
Reply |
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 |