Want my zeros

[pctechtv]

Hi, I have a special need to let Excel generate random numbers in a string of text like this.
="PCTECHTV"&(INT(RAND()*100000))&"INT3"
The result PCTECHTV34729INT3 with the random being 34729 or what ever it generates.
Now this if working for me except I need 5 numbers always and it is some time generating 4. I guess this is because some times INT(RAND()*100000) comes up with number s with zeros with it and that is fine but I want the zeros to show. I don't want to us INT(RAND()*100000) in a separate cell and format that to display 5 numbers and then have to add it to the =. Does any one know of a way to do this in the formula? Or?
Thanks

 

[MickG]

Perhaps:-

="PCTECHTV"& LEFT(REPT(INT(RAND()*100000),5),5)&"INT3"

Mick

 

[markmzz]

Pctechtv

Or try this:

="PCTECHTV"&INT(RAND()*(99999-10000)+10000)&"INT3"

Or

="PCTECHTV"&INT(RAND()*89999+10000)&"INT3"

Markmzz

 

[Kelbo]

Or perhaps:

="PCTECHTV"&TEXT(INT(RAND()*100000),"00000")&"INT3"

Kelbo

 

[mikerickson]

How about
="PCTECHTV" & MID(RAND(),3,5) & "INT3"

 

[Marcelo Branco]

Or

="PCTECHTV"&RIGHT("00000"&INT(RAND()*10^5),5)&"INT3"

M.

 

[pushkardey]

="PCTECHTV"&LEFT(RAND()*9^9,5)&"INT3"

to change the length of random number change the underlined number

hope this helps..

 

[pushkardey]

Or

="PCTECHTV"&RIGHT("00000"&INT(RAND()*10^5),5)&"INT3"

M.

i like your method too...nicely done...

 

[Marcelo Branco]

i like your method too...nicely done...

Thank you. I really appreciated.

M.