Rookie Needs Help!

  • Thread starter Thread starter storeman
  • Start date Start date
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
 
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.
 

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

Insert row(s) with vba 3
incrementing numbers with preceeding zeros 8
Leading Zero 11
How do I stop Excel from dropping leading zeros? 9
Replacing cell numbers but leaving leading zero 1
yearfrac format error? 4
time format 1
Need 7 digit number with differnt number of leading zeros 10

Back
Top