chris meardon
New Member
- Joined
- May 28, 2010
- Messages
- 5
Hi Guys,
I need to produce half a million random unique numbers onto a spreadsheet.
Can you guys help? obviously the rand function is ok but the numbers arent unique.
the numbers need to be within 1-9999
the other issue i have is displaying the numbers, all numbers need 4 digits, for example if the number is 35 it would need to be displayed 0035 to have 4 digits.
Thanks
I need to produce half a million random unique numbers onto a spreadsheet.
Can you guys help? obviously the rand function is ok but the numbers arent unique.
the numbers need to be within 1-9999
the other issue i have is displaying the numbers, all numbers need 4 digits, for example if the number is 35 it would need to be displayed 0035 to have 4 digits.
Thanks