Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically increment numbers in a cell when you open workbook
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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically increment numbers in a cell when you open workbook
See this:
http://mcgimpsey.com/excel/udfs/sequentialnums.html Biff "mrcall" wrote in message ... 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, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically increment numbers in a cell when you open workbook
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 "mrcall" wrote: 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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Form Numbers Automatically Increment by 1 Upon Opening | New Users to Excel | |||
A way to Open 2nd Workbook automatically | Excel Discussion (Misc queries) | |||
Run a macro automatically on workbook open | Excel Worksheet Functions | |||
open workbook automatically | Excel Discussion (Misc queries) | |||
increment cell value automatically | Excel Worksheet Functions |