How can I automatically decrement a column in hexadecimal numbers
 

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

How can I automatically decrement a column in hexadecimal numbers
 

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.

"Bonk33r" wrote:

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

How can I automatically decrement a column in hexadecimal numbers
 

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

"Bonk33r" wrote:

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

How can I automatically decrement a column in hexadecimal numbers
 

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

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