Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Create 5 of 6 digits randomly.
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")) -- Cheers macropod [MVP - Microsoft Word] "Shaun" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Create 5 of 6 digits randomly.
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")) -- Cheers macropod [MVP - Microsoft Word] "Dave Curtis" wrote in message .. . 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hard to do? randomly | Excel Worksheet Functions | |||
How to customize number to 10 digits including 2 digits after deci | Excel Worksheet Functions | |||
how do I create a Date field format for mm/dd/yyyy (10 digits) | Excel Worksheet Functions | |||
randomly selection | Excel Discussion (Misc queries) | |||
how do i create a spread sheet with randomly placed numbers 1-500. | Excel Discussion (Misc queries) |