How are you using the range?

In using a cell per number you can have a formula as so:
=IF(A1=999,1,A1+1)

Simply have the first cell as the value 1 and all the relevant cells number
formatted as 000

If I've mis-understood your use, could you give more info on how you use the
range please?

Basil

"Monique" wrote:

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