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" <Monique@discussions.microsoft.com> wrote in message
news:5D8C9F93-3AB7-471F-A635-F09379D23FD4@microsoft.com...
> 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