| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel: formula to generate an order number based on date
I am trying to create an order form that will generate an order number based
on the date the order is written. I would like to have the number shown without the slashes (/). Example: If the order is written on 2/23/07, I would like the order number to be 022307. Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| generate a random number and use if function to generate new data | Excel Worksheet Functions | |||
| Generate Auto Order Number | Excel Discussion (Misc queries) | |||
| How do I generate a new sheet based on date/week/month? | Excel Worksheet Functions | |||
| how, in excel, can i generate a number, eg consecutive order nos | Excel Discussion (Misc queries) | |||
| How can I generate number based on two measurements? | Excel Worksheet Functions | |||
Threaded Mode
