ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Generating random numbers (https://www.excelbanter.com/excel-worksheet-functions/252421-generating-random-numbers.html)

tobbey

Generating random numbers
 
How do i generate random 4 digit numbers using office outlook?

Joe User[_2_]

Generating random numbers
 
"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.

Mike Middleton

Generating random numbers
 
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?



All times are GMT +1. The time now is 05:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com