If you put this in A1, and copy down, you will get a sequence 1-5, then
1-5...etc

=MOD(ROW()-1,5)+1

Change the 5 to your last desired number (ie 999).
HTH
--
Dana DeLouis
Win XP & Office 2003


"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