Thread: Create 5 of 6 digits randomly.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Dave Curtis Dave Curtis is offline
external usenet poster
  
Posts: 100
Default Create 5 of 6 digits randomly.
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
Reply With QuoteReply With Quote