how can i put a unique number in a header for a git certificat for
 

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

You can generate a unique number with:

=SUBSTITUTE(NOW(),".","")

HTH
Jason
Atlanta, GA


-----Original Message-----
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
.

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