View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Shaun Shaun is offline
external usenet poster
 
Posts: 47
Default Create 5 of 6 digits randomly.

I would like to create a random conformation number, but only make the last 5
of 6 digits random. I would like to make the first number be the hour witch
the meeting time will start. For ex. (743856) 7 for 7:00 and the other 5
would be random. Any help would be greatly appreciated.