Add leading zero to =DEC2HEX(SEQUENCE(100,1,1) formulas

[speednet]

Hi there,

Based on the above formula, how do I add leading zero and maintain 4 alphanumeric digits? Thanks in advance

from
1
2
3
4
5
6
7
8
9
A
B
C
D
E
F


To
0001
0002
0003
0004
0005
0006
0007
0008
0009
000A
000B
000C
000D
000E
000F

 

[kevin9999]

=RIGHT("0000"&DEC2HEX(SEQUENCE(100,1,1)),4)

 

[speednet]

Appreciate your prompt reply. The formula works. Many thanks

 

[kevin9999]

Appreciate your prompt reply. The formula works. Many thanks

Happy to help & welcome to the forum

 

[speednet]

Hi Kevin,

I have another query that is I have a list of hexadecimal in the running sequence from a row starting from 0001 to 02DD.
Any formula which I can use to identify if any of the hexadecimal is missing from the list and list out the missing hexadecimal in another column. Thanks in advance

 

[kevin9999]

Hi Kevin,

I have another query that is I have a list of hexadecimal in the running sequence from a row starting from 0001 to 02DD.
Any formula which I can use to identify if any of the hexadecimal is missing from the list and list out the missing hexadecimal in another column. Thanks in advance

That one's a bit beyond me. If you post another question, I'm sure there'll be someone who can help

 

[speednet]

Noted with thanks

 

[Fluff]

For reference, Hex2Dec allows you to specify string length so you could just use

=DEC2HEX(SEQUENCE(100,1,1),4)

 

[speednet]

For reference, Hex2Dec allows you to specify string length so you could just use

=DEC2HEX(SEQUENCE(100,1,1),4)

Thank you, Moderator

 

[Fluff]

Glad we could help & thanks for the feedback.