Create 5 of 6 digits randomly.

[Shaun]

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.

 

[macropod]

Hi Shaun,

Perhaps:
=A1&TEXT(INT(RAND()*10^5),"00000")
where A1 contains the fixed value. If you need the result as a number, you could use:
=VALUE(A1&TEXT(INT(RAND()*10^5),"00000"))

 

[Dave Curtis]

Hi Shaun,

Simplifying macropods answer slightly, you can use

=--(A1&INT(RAND()*10^5))

to give you the result you need. The double negative coerces the result of
the concatenation into a number.

Dave

url:http://www.ureader.com/msg/10356918.aspx

 

[macropod]

Hi Dave,

Unfortunately, that approach drops the leading 0s from the value returned by the RAND function. You could use:
=--(A1&TEXT(INT(RAND()*10^5),"00000"))