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

K

Konstantine

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
 
J

Jason Morin

You can generate a unique number with:

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

HTH
Jason
Atlanta, GA
 
M

Michael

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
 
Top