Unique Code Generator
Free Code Generator Online
Hello, Good day. I would like to generate a unique ID from date and a customer number field. I tried this way but it was not working as desired. Below is how I started off. Customer number in A2 is 12345 =today()&$A2 The result seems to be okay when I saved the file. However, when I opened the file again the next day, the ID was different as it used the date of the day I open the file to generate the unique ID. How should I work around this?
The Free Barcode Generator of Choice. Generate high resolution 1D and 2D barcodes in the most popular barcode fonts like EAN, POSTNET, UPC, DataMatrix, CODABAR, PDF417, ISBN, Code 39, Code 93, Code 128. The barcode generator is absolutely free, and is up and running 24/7 to help you get the barcodes you need quickly and efficiently.
Appreciate the advice. Thank you in advance for the help. Best regards, wliang. Formula will not work like this.
As the formula would be calculated each time Your requirement is not clear to me. I am assuming that you would be entering customer id in cell A2, and in B2 you would like to see some thing like what you tried. So either you use the formula and then use copy - paste special as values manually or do the same by a macro Since the macro would depend on your usage of the book like id can change, id remains same, id can repeat on row etc, it is hard to give you any concrete answer.