Binary code formula help

[serge]

Hi everyone,

I have this formula :

=DEC2BIN(MOD(A1,2^20)/2^16,4)&DEC2BIN(MOD(A1,2^16)/2^8,8)&DEC2BIN(MOD(A1,2^8),8)

What I'm looking for is (2) formulas.

One that will give me a total of 6 digits no matter what the number to transfer is from 1 to 63.

Example : 1 would show : 000001
23 would show : 010111

and the second a total of 7 digits, same thing 1 to 127.

Thank you, Serge.

 

[West Man]

Take a look at the second argument for the DEC2BIN function. It allows you to specify the number of binary digits desired.

 

[serge]

I tried to change the 20 to a 6 or 7, but it wouldn't change anything if that what you refer ?
That's why I ask for help I don't know how to make it happen ??

 

[West Man]

Try DEC2BIN(your formula,7) to get a 7 digit result. But based on your comment "I tried to change the 20 to a 6 or 7" I am unsure what your are trying to accomplish. Give us an explaination of the goal of your formula and perhaps we can help.

 

[serge]

Thanks for the reply West Man,

What I need is that the formula give me in return a total of 6 digits, if I want to get the binary code of the number 1, I need it to be 000001 and not just 1 like : =DEC2BIN(A1) would give me, or if I want the binary code of the number 15, I need the return to be 001111 and not 1111.

That's all, but I don't know how to change the formula !!!

 

[West Man]

Try DEC2BIN(A1,6)

 

[serge]

Thank you West Man, it works, I appreciate the help.
Serge.