Automatically increment numbers in a cell when you open workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to automatically increment invoice numbers on an invoice. The
number type I use 00-000222 and 3443-000123. could someone please show me how
to do it,
 
The information at the McGimpsey site shows a way to do this with .txt files
and a way using the registry. Since you have two different series going,
you'll probably want to use the .txt file solution.

Also, his method is based on invoice numbers being actual numbers, but for
the format you have you'll need to look at combining numbers and text, or
converting number from the text file and then formatting them as text with
leading zeros so that they appear on your invoices properly.

If you need assistance with that type of thing, feel free to post back here
or even to contact me at (remove spaces) HelpFrom @ jlathamsite.com
 

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

Saving a copy without incrementing number 10
Recurring Numbers 8
template creates invoice - how to create summary worksheet? 13
How do I fill adjacent cells with incrementing numbers 2
Auto Number 1
incrementing account numbers 5
Add 1 to a cell 2
numbering items in a cell 5

Back
Top