DEC2BIN Query

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