Reply to thread

Message: [QUOTE="Max, post: 5190210"] 3 possible options? 1. Check out the excel template INVOICE.XLT, usually found at path: C:\Program Files\Microsoft Office\Templates\Spreadsheet Solutions\INVOICE.XLT This template has the option to generate unique sequential numbers. 2. Try : [URL]http://tinyurl.com/sijt[/URL] where MVP Leo Heuser provides 2 subs 3. A non-macro way suggested by MVP Norman Harker previously (below): --------------------------------------------------------- From: Norman Harker (nharker@ozemail.com.au) Subject: Re: invoice number macro View this article only Newsgroups: microsoft.public.excel.programming Date: 2001-08-21 04:52:34 PST Hi Ruud! For any given number of invoices the possibility of non-unique numbers being generated using random numbers increases with the number of invoices. I would suggest a non-random method: =INT(NOW()*1000000) returns 37124908872 This returns a number that will be unique as long as no-one generates another invoice within 1/100th of a second (assuming their computer clock is in synchronization with yours). You could say that it has an advantage in that with the invoice number you can determine the date and time of issue. hth [/QUOTE]