| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dates changing when opening a CSV
Hi there
I am opening a CSV file with a bank account statement details in. Excel is changing the date for mat for some of the dates (but not all of them). So 01/08/2008 (1 Aug 08) is becoming 08/01/2008 (8 Jan 08), but this only happens for dates before the 12th of every month. It's really irritating! If I open the CSV manually, it works fine, but with my macro it changes. I can't figure out a solution... PLEASE HELP! ps. I am using Office 2003. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening a file whose name is continuously changing | Excel Programming | |||
| Changing column width for opening *.csv in Excel | Setting up and Configuration of Excel | |||
| Changing Opening folder | Excel Worksheet Functions | |||
| Opening a file with changing dates | Excel Programming | |||
| Opening Excel after changing settings and add-ins | Excel Discussion (Misc queries) | |||
Threaded Mode
