I am working on a workbook that assists in building data to generate a telemetry string. It seems that I must build the string one "0" or "1" at a time, then convert my sixteen character binary looking string to decimal or hex. But when C3 contains "00010100100" and D3 contains "=BIN2DEC(C3) I get an conversion error.
How do I resolve that?
Just in case someone knows a much more elegant, and maybe built in solution: Another way of looking at the problem is that I need to build a 16 bit number, then change the format from big endian to little endian. When the left 8 bits get moved to the right side, all the leading zeroes must be retained. After the 16 bit word is created, then I need to convert to decimal.
How do I resolve that?
Just in case someone knows a much more elegant, and maybe built in solution: Another way of looking at the problem is that I need to build a 16 bit number, then change the format from big endian to little endian. When the left 8 bits get moved to the right side, all the leading zeroes must be retained. After the 16 bit word is created, then I need to convert to decimal.
