Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change date format
Good day,
Thanks for all the help with my previouse queries, i am from South Africa so there is quite a time delay. I have two spread sheets and i copy a purchase order number from one to the other using a Vlookup, which works fine, however i now need to copy the date of the same order but require a different format. The original format is text 20041105 and i need it to be 05-Nov-04 in the new workSheet. The formula i am using is; ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-23],LCS_Complete_E90.xls!C1:C12,2,0)" Some help with some code would be appreciated. Thanks Tempy *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change date format dd/mm/yyyy to Julian date format? | Excel Worksheet Functions | |||
Change Date Format to Specific Text Format When Copying | Excel Discussion (Misc queries) | |||
Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
Change a date in text format xx.xx.20xx to a recognised date format | Excel Programming |