| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/Paste dates from CSV file - date format error?
Hi All,
Using Excel 2003 & Windows XP, UK regional settings. I am developing a solution that is very date dependent and requires a csv file to be produced from an external source. Data from the csv file is then copied & pasted into an Excel workbook. However it seems that although the dates in the csv file are in UK format when they get pasted into Excel they are in US format but only for days 1 to 12. I seem to remember something from the dim & distance path that Microsoft knew of this 'limitation'. Can anybody 1) confirm this is a known error / limitation in XL2003 2) suggest a workaround 3) provide code for a workaround All help gratefully appreciated. Kind regards Michael Beckinsale |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing date format in copy paste | Excel Discussion (Misc queries) | |||
| Date copy, Paste error | Excel Discussion (Misc queries) | |||
| Copy/Paste Special (Date Format) | Excel Discussion (Misc queries) | |||
| Copy-Paste sheets - error in the dates | Excel Worksheet Functions | |||
| copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro | Excel Programming | |||
Threaded Mode
