Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
How do i generate random 4 digit numbers using office outlook?
|
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
"tobbey" wrote:
How do i generate random 4 digit numbers using office outlook? If your question is really about Outlook, of course you should post it to an Outlook discussion group. On the off-chance that you simply mistyped and you are really asking about Excel, you really have not given enough details to answer the question. Interpreting you literally, the answer could be as simple as: =RANDBETWEEN(0,9999) formatted with the Custom format 0000 . Note that that might generate some 4-digit numbers with leading zeros. You might consider those to be 1-, 2- or 3-digit numbers. Also note that, unfortunately, the number will change every time you edit the workbook -- any cell(!). You might find that undesirable. |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
tobbey -
To generate 4-digit random numbers in Excel, you could use =INT(RAND()*10000) - Mike http://www.MikeMiddleton.com "tobbey" wrote in message ... How do i generate random 4 digit numbers using office outlook? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Generating Random numbers. | Excel Discussion (Misc queries) | |||
generating random number list | Excel Worksheet Functions | |||
Generating random numbers with the occasional outlier | Excel Worksheet Functions | |||
Generating Random Number from a set of numbers | Excel Discussion (Misc queries) | |||
generating random number as template | Excel Discussion (Misc queries) |