Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Meredith" wrote in message ...
| Hi there,
|
| I'm trying to create a process form for an ordering department in our
| company that will generate a new order number in one of the cells each time a
| new order is created.
| Once the order is created though, I don't want the number to change until a
| new order is created. Does this make sense?
| I've tried looking through the forums and Googling it, but haven't been able
| to find an answer.
|
| Can anyone help me with this one,
| Thanks!