DEC2BIN Query

[anupambit1797]

Dear Experts,

                   Need a help on DEC2BIN, as we have limitation that beyond 511, Excel can't decode, is there any trick to convert below into BIN? with Matlab I can do this but one-by-one converting ~ 1000 entries is not feasible..

Using Matlab:-

Also , need to add another column that gives the position of "1s" bit in this bitmap from LSB,

Many Thanks

Br,

Anupam

[#2]

@anupambit1797 

Workarounds are here vba - Decimal to binary conversion for large numbers in Excel - Stack Overflow

You may try BASE() function.