Look he
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"kitten74" wrote in message ...
| Hello All,
|
| I'm using Microsoft Excel 2000. Does anyone know if it's possible to
| create a document that has one dedicated cell with a number that changes
| every time the document is open? (i.e. i'm creating a quotation template,
| and would like to have a new quotation number appear every time the template
| is open). Maybe using a template is not the way to go, so if you have any
| suggestions, I would appreciate them. Thank you.