How can I automatically decrement a column in hexadecimal numb
Thanks for your feedback. I am glad TOm had the HExidecimal portion of the
asnwer. I too have learned something.
"Bonk33r" wrote:
What I ended up doing was using both of your answers and adding a little
more. I used Tom's idea of starting at 211, then put 210 below it and used
Wiley's idea of decrementing by highlighting 211 and 210 then dragging the
fill handle. Then I used DEC2HEX and converted the numbers to hexadecimal.
I then copied the column and pasted it where I wanted it. It first gave me a
bunch of ####'s, but then I clicked on the paste icon and selected "Values
Only". I went back and deleted the two columns I used to create this new one
and all is well.
Thanks again,
Bonk
|