I should have added that these numbers are listed from A1-22 and will
continue at C1-22 and E1-22. At any given point the cell may reach 999 but
usually not in the same day or the same cell. Therefore, I need to format all
of them to meet my condition of 1-999. The formula works, but I don't know
how to continue it in cell C1. I originally created the formula for the
number as =A1+1 in the second cell, A2.
A1 C1(A22+1 entered)
=A1+1 C2 (C1+1 entered)
A2+1 to C22
to A22

I am not sure how to put both formulas together.

Thanks for your help, as I am new at this.

Monique


"Basil" wrote:

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