It works all the way to:
00-00-54-00-3A-FF
But then it goes to:
00-00-54-00-3A-100
It needs to go to 3B-00

How can I keep it at 2 digits?


"Dave Peterson" wrote:

Maybe you could use a formula and drag that down.

I put this in A1:
="00-00-54-00-3A-"&DEC2HEX(HEX2DEC(66)+ROW())
And got:
00-00-54-00-3A-67
00-00-54-00-3A-68
00-00-54-00-3A-69
00-00-54-00-3A-6A
00-00-54-00-3A-6B
.....

Depending on your starting row (and your ending quintet), you may have to fiddle
with that expression.

Bryan wrote:

"Bryan" wrote:

Hey all, I have a list of hex numbers I need to increment. The dec2hex
method won't work here as my numbers look like the following:
00-00-54-00-3A-67
I have seen this in a column with a one thousand incremented in the list.
There has to be a way to do it, but I have no clue! Any ideas? Thanks for
your help!

Let me be slightly more specific:

00-00-54-00-3A-93
00-00-54-00-3A-94
00-00-54-00-3A-95
00-00-54-00-3A-96
00-00-54-00-3A-97
00-00-54-00-3A-98
00-00-54-00-3A-99
00-00-54-00-3A-9A
00-00-54-00-3A-9B
00-00-54-00-3A-9C
00-00-54-00-3A-9D
00-00-54-00-3A-9E
00-00-54-00-3A-9F
00-00-54-00-3A-A0
00-00-54-00-3A-A1
00-00-54-00-3A-A2
00-00-54-00-3A-A3
00-00-54-00-3A-A4
00-00-54-00-3A-A5
00-00-54-00-3A-A6
00-00-54-00-3A-A7
00-00-54-00-3A-A8
00-00-54-00-3A-A9
00-00-54-00-3A-AA

That is what I mean by increment. Thanks!

--

Dave Peterson