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

H

hon123456

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
 
R

Ron Rosenfeld

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.
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I set the numerical type of Cell to Hex format 2
add one to cell below 4
Comparing columnar data to row data 3
Convert text to number automatically 1
Auto fill numbers starting with zero 3
How to lookup based in the first 3 characters of a cell 2
Link Access to Excel export back to excel 3
Format date in a cell 2

Top