Have the first number of a serial in one cell and the last serial in another cell, and have a sheet fill in the rest?

[BAQI]

Example of what I'm looking for:

A2 = ABCDEF (an item that needs to be serialized)
B2 = 001 (the start serial)
C2 = 008 (the end serial)

A3 = UVWXYZ
B3 = 004
C3 = 011

Another sheet creates the following automatically:

A2 = ABCDEF
B2 = 001

A3 = ABCDEF
B3 = 002

A4 = ABCDEF
B4 = 003

.......

A9 = ABCDEF
B9 = 008

A10 = UVWXYZ
B10 = 004

A11 = UVWXYZ
B11 = 005

......

A17 = UVWXYZ
B17 = 011

I'm trying to keep one page clean, and save time by not having to do repetitive steps.

 

[kweaver]

The software I'm using is p-touch editor. It's for printing labels.

Have no familiarity with that software. Sorry.

 

[BAQI]

Have no familiarity with that software. Sorry.

If in another cell I do =TEXT($B2,"000") THAT shows up properly. How is =TEXT any different than:

Sheets("NewSerials").Range("B:B").NumberFormat = "###"

And is there a way to edit the .NumberFormat = "###" to be a text format instead?

 

[kweaver]

Will this accomplish what you want (adjust ref as needed):

Sub FmtNum()
Range("C10").NumberFormat = "@"
Range("C10") = Format(Range("B10"), "000")
End Sub