| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
random number in a cell
I am trying to find a way to generate a random number (used for an invoice
number) in a certain cell, each time a the workbook is opened. So far I have only been able to generate a random number each time anything is input into the spreadsheet. Any suggestions?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
random number in a cell
See this:
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Biff Microsoft Excel MVP "just4fun" wrote in message ... I am trying to find a way to generate a random number (used for an invoice number) in a certain cell, each time a the workbook is opened. So far I have only been able to generate a random number each time anything is input into the spreadsheet. Any suggestions?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Random cell/number and dont repeat selected cell/number | Excel Discussion (Misc queries) | |||
| Addding a Random number to a fixed number..... | Excel Discussion (Misc queries) | |||
| How can I match a random number with closest number from sequence? | Excel Worksheet Functions | |||
| Generating (in a random order)each number once from a given number | Excel Worksheet Functions | |||
| How do I find random number in list of random alpha? (Position is. | Excel Discussion (Misc queries) | |||
Hybrid Mode
