View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Wiley Wiley is offline
external usenet poster
 
Posts: 86
Default 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