Creating consecutive numbers to be used as invoice numbers

Hi everyone,

I'm using an excel spreadsheet to record customer data that will eventually be populating a pdf form. I need to have a column in excel that will create consecutive invoice numbers for each customer record.

Can someone show me how to do this if it's possible in excel?

Appreciate any help.
LVL 1
gwh2Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
DaveConnect With a Mentor Commented:
You could try this variant
="Go"&TEXT(ROW()-ROW($A$2)+1,"0000")
where $A$2 is always the first cell in your list (so A2 gives 1, A3 gives 2 etc)
or just
="Go"&TEXT(ROW()-1,"0000")
to hardcode subtracting 1
 
Cheers
Dave
0
 
QPRCommented:
you could type an initial value in a cell and then go to Edit / Fill / series and click on "step value" and enter 1.
0
 
gwh2Author Commented:
Thanks for the reply,

I just tried your suggestion. I have 1 initial record and one of the column headings is called invoice_no. I went to the first record (row) and clicked in the cell below the heading called invoice_no and typed in an initial value, ie. GO0001. I then went to Edit > fill > fill series and put in 1 next to "step value" as you suggested. But then when I click in the cell below the one I just created, nothing happens, ie. the next value doesn't come up.

Do you know what I'm doing wrong?
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
DaveCommented:
If you put
="Go"&TEXT(ROW(),"0000")
in A1
and copy down
then yuou will get an incrementing list Go0001, Go0002 etc
Cheers
Dave
0
 
QPRCommented:
Ahhh so we aren't talking numbers strictly then
you will need to create some sort of formula that will take the numeric portion of your invoice value, add 1 to it then string it back together.... something I couldn't do off the top of my head and would need to Google.
A quick qorkaround may be to span the invoice value over 2 columns with 1 column just having the GO and the next column having the step value
0
 
QPRCommented:
oops qorkaround = workaround!
But ignore that, Dave has hit the nail on the head.
0
 
gwh2Author Commented:
Thanks - the formula works great but what if I need to have a heading in A1? If I put the formula in A2 it starts at GO0002. Is there a workaround?
0
 
gwh2Author Commented:
Perfect! Thanks a million.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.