| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 . |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort a column a unique number? | Excel Worksheet Functions | |||
| Count number of unique items in a column that contains duplicates | Excel Worksheet Functions | |||
| How do i number pages in a header consequently | Excel Worksheet Functions | |||
| Count number of Unique values | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
