Fill a column with hex numbers

I want to fill a column with incrementing hex numbers that
are slaved to the top cell (A1) so it can be changed. For
example:

1008
1009
100A
100B
etc.

I have tried this formula in the 2nd cell:

=DEC2HEX(HEX2DEC($A$1)+1)

I want to drag it down to fill with this:

=DEC2HEX(HEX2DEC($A$1)+1)
=DEC2HEX(HEX2DEC($A$1)+2)
=DEC2HEX(HEX2DEC($A$1)+3)

But when I drag it down to fill, it won't increment.

I want each cell to be slaved to A1, not the previous
cell, because I want to be able to insert and delete rows
without affecting the existing values.

Thanks.
Ronald

This is a good place to use ROW()

If you're starting on row2 referring to A1, try

=DEC2HEX(HEX2DEC($A$1)+ROW()-1)



"Ronald" wrote in message
...
I want to fill a column with incrementing hex numbers that
are slaved to the top cell (A1) so it can be changed. For
example:

1008
1009
100A
100B
etc.

I have tried this formula in the 2nd cell:

=DEC2HEX(HEX2DEC($A$1)+1)

I want to drag it down to fill with this:

=DEC2HEX(HEX2DEC($A$1)+1)
=DEC2HEX(HEX2DEC($A$1)+2)
=DEC2HEX(HEX2DEC($A$1)+3)

But when I drag it down to fill, it won't increment.

I want each cell to be slaved to A1, not the previous
cell, because I want to be able to insert and delete rows
without affecting the existing values.

Thanks.
Ronald