Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
I was wondering whether anyone knew how to do the following: How do I create a formula that continuously numbers my invoices, e.g. 001 (first invoice) then when I go to type another invoice it numbers is 002. PLEASE HELP! Cheers |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
A couple of ways here. http://www.mcgimpsey.com/excel/udfs/sequentialnums.html Mike "Revive-A-Disc" wrote: Hi, I was wondering whether anyone knew how to do the following: How do I create a formula that continuously numbers my invoices, e.g. 001 (first invoice) then when I go to type another invoice it numbers is 002. PLEASE HELP! Cheers |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
Take a look at J E McGimpsey's solution at http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Regards Roger Govier "Revive-A-Disc" wrote in message ... Hi, I was wondering whether anyone knew how to do the following: How do I create a formula that continuously numbers my invoices, e.g. 001 (first invoice) then when I go to type another invoice it numbers is 002. PLEASE HELP! Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HOW TO CREATE 2 IDENTICAL INVOICES ON 1 A4 SHEET | New Users to Excel | |||
How do I create invoices from an Excel spreadsheet? | New Users to Excel | |||
How do I create a counter for invoices, order numbers etc | New Users to Excel | |||
create invoices | New Users to Excel | |||
Create invoices from excel workbook | Excel Worksheet Functions |