| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date problem when opening a csv with dates in dd-mm-yyyy format.
When I open a csv with a date in one "cell" excel allways interprets the date
as mm/dd/yyyy if I do it in VBA, but if I open the CSV manually then excel interprets the date according to my system date settings. How can I tell excel how to interpret the date within VBA when opening a CSV? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change date format from dd/mm/yyyy to mm/yyyy | Excel Discussion (Misc queries) | |||
| Help with date format mm/dd/yyyy vs. dd/mm/yyyy | Excel Discussion (Misc queries) | |||
| how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel | New Users to Excel | |||
| opening excel file - date format problem: DD/MM/YYYY vs MM/DD/YYYY | Excel Programming | |||
| Having problem getting date into format: yyyy/mm/dd | Excel Programming | |||
![Jeroen Hofs[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
