binary conversion

hi i am looking to make a binary convertor using excel. only a small one. e.g

8 4 2 1
0 0 0 0 0
0 0 0 1 1
0 0 1 0 2
0 0 1 1 3
0 1 0 0 4
0 1 0 1 5
0 1 1 0 6
0 1 1 1 7
1 0 0 0 8
1 0 0 1 9
1 0 1 0 10
1 0 1 1 11
1 1 0 0 12
1 1 0 1 13
1 1 1 0 14
1 1 1 1 15



i would like to know if anyone knows the formulae to turn decimal into binary , thanks

you have to install Analysis Tool pack
go to menu Tools > Add-Ins...
check Analysis ToolPak then Ok (it will ask you to install if it is not)
after installation use DEC2BIN function (you can have guidance to use this function from Excel help)

Regards

Originally Posted by binaryuser

hi i am looking to make a binary convertor using excel. only a small one. e.g

8 4 2 1
0 0 0 0 0
0 0 0 1 1
0 0 1 0 2
0 0 1 1 3
0 1 0 0 4
0 1 0 1 5
0 1 1 0 6
0 1 1 1 7
1 0 0 0 8
1 0 0 1 9
1 0 1 0 10
1 0 1 1 11
1 1 0 0 12
1 1 0 1 13
1 1 1 0 14
1 1 1 1 15



i would like to know if anyone knows the formulae to turn decimal into binary , thanks