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?
 
Dave BrettConnect With a Mentor Vice President - Business EvaluationCommented:
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
Free tool for managing users' photos in Office 365

Easily upload multiple users’ photos to Office 365. Manage them with an intuitive GUI and use handy built-in cropping and resizing options. Link photos with users based on Azure AD attributes. Free tool!

 
Dave BrettVice President - Business EvaluationCommented:
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
All Courses

From novice to tech pro — start learning today.