| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How Can I conver date i.e 18/11/2005 to 18112005.?
Hi
I am doing one Pruchase Order form in Excel. I want to creat the PO number as if date being Displayed in regular number. i.e 18/11/2005 as if 18112005 and than followed by "-" and increasing value. If I will open and print off 5 times in a day. The last number has to be 18112005-5. Is there anybody can help me on it. Kind Regards Manish |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Imported data changes to date format (5-1-5 changes to May 1, 2005 | Excel Discussion (Misc queries) | |||
| I have a date 51231 (2005,dec,31) -I want to change to 2005/12/31 | Excel Worksheet Functions | |||
| Convert alphanumerical(eg. 12.11.2005) to date as 12-Nov-2005 in e | Excel Discussion (Misc queries) | |||
| how do i update the date on a 2005 calendar template | Excel Discussion (Misc queries) | |||
| chnage date from tuesday 4 January 2005 10:39.26 to 04/01/2005 | Excel Worksheet Functions | |||
Threaded Mode
