Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert a number upto 100 to binary
Has anybody got a piece of code that can convert a nuber in a cell, say A1
and display it as a 7 digit binary number in B1? I have tried to do this working from the 7th digit backwards using combinations of 'if' and 'and' functions, but by the time I get to the 5/4 digits I am losing the will to live! Many thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert binary to decimal | Excel Discussion (Misc queries) | |||
formula to round up any number less than 35 upto 35. | Excel Discussion (Misc queries) | |||
decimal number convert to 16bit binary | Excel Programming | |||
Convert Binary to Hex | Excel Programming | |||
Convert SpreadsheetML to binary .xls | Excel Programming |