How can I automatically decrement a column in hexadecimal numbers

[Guest]

First, is it possible to decrement numbers like you can increment them with
the fill handle?

Second, is it possible to increment or decrement hexadecimal numbers?

My problem is inputing data down a column that starts at D3 and ends in 9E.
I would like to be able to do this quick and simple.

TIA,
Bonk

 

[Guest]

Excel recognizines certain patterns with the fill handle. You have to tell
ti what pattern. To decrement, just create the first secquencial #'s in 2 or
3 adjacent cells. Highlight those cells together, and drag with the fill
handle.

I 'm sorry. I don't know of a way to increment hex numbers.

 

[Guest]

I don't know how to make Excel increment/decrement hexidecimal numbers
without writing a VBA routine.

If you have the Analysis Toolpak installed (Tools >> Add-Ins), you can do
the following:
Hex D3 is decimal 211. Put 211 in cell A1. In A2, enter =A1-1
Copy this down through row 54, which should equal 158 (9E hex).
In cell B1, enter =DEC2HEX(A1) and copt down through row 54.

Hope this helps,

Hutch

 

[Guest]

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

 

[Guest]

Thanks for your feedback. I am glad TOm had the HExidecimal portion of the
asnwer. I too have learned something.