How to add the number in cell one by one in Hex format
 

Dear all,

Now, if I type in 01/0001 in cell, and then I drag the mouse down to

many cells , the number in the cell will be added by 1 automatically, just

like the following

01/0001
01/0002
01/0003

On 13 Jan 2005 03:04:49 -0800, (hon123456) wrote:

Dear all,

Now, if I type in 01/0001 in cell, and then I drag the mouse down to

many cells , the number in the cell will be added by 1 automatically, just

like the following

01/0001
01/0002
01/0003
.
.
.

Now, if I type in 01/0001 and I want to drag the mouse down to many cells

and I want the cell to add 1 automatically in Hex format. Can I do that?

Simply, I want the cell to add 1 automatically in Hex format.

Just like that

01/0001
.
.
01/0009
01/000A
01/000B
01/000C
01/000D
01/000E
01/000F
01/0010

Please help. Thanks.

One method:

Assume your initial entry is in A1.

In A2 enter the formula:

=LEFT(A1,3)& dec2hex(hex2dec(RIGHT(A1,4))+1,4)

then drag down the formula as far as necessary.

If the Hex2Dec function is not available, and returns the #NAME? error, install
and load the Analysis ToolPak add-in.

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click
OK.
If necessary, follow the instructions in the setup program.


--ron