LinkBack URL
About LinkBacks
Hello,
Would like to streamline my quoting process with a formula that would create a unique ID using the current date and time
3/21/16 10:16 becomes 321161016
thank yo in advance!
Formula to create unique ID using DATE & TIME
Hello,
Would like to streamline my quoting process with a formula that would create a unique ID using the current date and time
3/21/16 10:16 becomes 321161016
thank yo in advance!
try
=TEXT(NOW(),"DDMMYYHHMM")
will not be unique if used within 1 minute of course
so you could add SS for seconds
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Re: Formula to create unique ID using DATE & TIME
Well that works! Very well thank you.
You are a gentleman and a scholar.
Kurt
you are welcome
if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks