Feb 13 2023 08:55 AM
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
Feb 13 2023 09:03 AM
Workarounds are here vba - Decimal to binary conversion for large numbers in Excel - Stack Overflow
You may try BASE() function.