Rookie Needs Help!

S

storeman

I would like to create a formula that increments the value of one cell
Here's the dilemma. A5 contains a number entered as text, 001. I nee
to keep that format and have 002 in B5. These are item numbers and I a
trying to avoid having to manually enter each number in the next cell.
can do this easy enough with numbers that do not have leading zeros bu
can not seem to do it using leading zeros. Is this possible?

Th
 
P

Paul Corrado

This may work. I'm assuming "001" is in A1

=TEXT(VALUE(A1)+1,"000")

Copy down

You can also drag the fill handle (at the bottom right corner of the cell)
down and the text should increment by 1. If the increment is some other
number ("005") for example put those two values in A1 & A2, highlight both
cells and drag down.
 
Top