Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
rolling 4 digit numbers for 4d?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
rolling 4 digit numbers for 4d?
Hi,
1. Please put your questions in the body of the email, when we press Replay in the Web interface we get "An error occurred while sending your post -------------------------------------------------------------------------------- We're sorry, but there was a problem with the system and your post was not received. The error has been reported to Operations and will be investigated as soon as possible. Please try again later." 2. what is your question? -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Curious" wrote in message ... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
rolling 4 digit numbers for 4d?
I think this is what you want:
=INT(6*RAND()+1)*1000+INT(6*RAND()+1)*100+INT(6*RA ND()+1)*10+INT(6*RAND ()+1) In future, use the message body to explain what you want, rather than try to cram it into the header. Hope this helps. Pete On Jan 8, 6:43*am, Curious wrote: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Store numbers starting with zero as 2 digit numbers | Excel Discussion (Misc queries) | |||
How do I sum numbers in rolling format? (4 qtrs=4 cells to left) | Excel Discussion (Misc queries) | |||
what is the minimum numbers set for 4 digit numbers from 0000 to 9 | Excel Discussion (Misc queries) | |||
Z Chart i.e. top rolling annual bottom rolling monthly middle cum. | Excel Worksheet Functions | |||
16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO | Excel Worksheet Functions |