Hi Monique

Format your cells Custom=000
Enter in cell A2
=IF((A1+1)999,A1+1-999,A1+1)

This will work until you get to 1999 at which point you would either need to
type in a new starting value, or amend the formula to subtract 1999

--
Regards
Roger Govier
"Monique" wrote in message
...
Hi,

I am looking for a formula that has a consecutive number range starting
from
001 and ending at 999. I do not use all of them in one day. My goal is
to
be able to revert back to 001 when the last number of my sequence (999) is
reached automatically. This is for an excel spreadsheet that does not
expand beyond 999.

Thank you for your help!

Monique