| 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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel: formula to generate an order number based on date
If your date is in A1, use this formula:
=TEXT(A1,"mmddyy") This assumes only one order per day. Hope this helps. Pete On Feb 23, 8:19 pm, Gina Hastings <Gina wrote: 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel: formula to generate an order number based on date
You don't even need th eformula. Use in the Format Menu - Number - Custom.
enter new custom format mmddyy. It is equivalent to what Pete recommended. the mmddyy in the formula says to use custom formating. "Pete_UK" wrote: If your date is in A1, use this formula: =TEXT(A1,"mmddyy") This assumes only one order per day. Hope this helps. Pete On Feb 23, 8:19 pm, Gina Hastings <Gina wrote: 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? |
| Reply |
| 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 | |||
Hybrid Mode
