Hi Konstantine
In addition to Jasons formula.
If the number is too big for your needs, try this:

=RIGHT(SUBSTITUTE(NOW(),".",""),8)
Where the 8 on the end can be changed to suit how many digits you desire.

HTH
Michael

"Konstantine" wrote:

If i were printing gift certificates, in excel, and I wanted to put a unique
number on each one that was printed, how would i do this
I know i can put the time and date and page number on the footer, but that
number does'nt change
can someone please help