Look he

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Madiha" wrote in message ...
|I have to create invoices on Excel. How should i make certain that when the
| invoice is opened, a new invoice number is generated? SO that there are no
| duplicates.