Unique id generator

[janakG]

School project:creating a booking system that will generate a unique id every time some one books a show. I have the formula to produce a unique id but every time I move onto the next cell the id changes so after I finished typing in a name and move onto typing in the email the id changes. My excel skills are very basic so anyone have a simple solution?

Formula to create id:=(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(100,99999)

Example of how it look below

ID: Formula in here
Name:
Email:
Select show:<attachment></attachment><attachment></attachment><attachment></attachment>

 

[ranman256]

or you can just use the date/time at that very second...
=Format(Now,"yymmddhhnnss")