Converting Decimal to Binary & vice versa

[Zhuge-Liang]

Greetings,

I was hoping someone would be kind enough to help me out with a small dilemma.

Is there a formala or macro which would enable me to convert an 8-bit binary number to decimal and vice versa.

Example 1. 11111111 =256
Example 2. 00000001 =1
Example 3. 01010101 =85

Basically i want to be able to input a number in to a cell and then select either of two buttons. Button 1 would convert to binary, whilst button 2 would convert to decimal.

It is only necessary to have up to 8 bits of data, although anything above that would be a great asset too.

Just some help with binary. I am placing the headers below.


128 64 32 16 8 4 2 1


Thanks for your help.

 

[Richard Schollar]

Assuming you have the Analysis Toolpak installed, you can use the function Dec2Bin and Bin2Dec:

in B1 if A1 contains 256:

=Dec2Bin(A1)

Then in C1:

=Bin2Dec(B1)

 

[Zhuge-Liang]

That's great.

Thank you very much!