| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date format not correct when you convert a CSV text file in Excel
Have to tried the workaround mentioned in the article, using the Local
argument? I switch my settings to UK and I found that using Local fixed the problem: Workbooks.Open Filename:="C:\date.csv", Local:=True -- Jim "Scarab" wrote in message ... | Within my CSV file the date is in the format dd/mm/yyyy, when I convert it | into Excel 2003 the date appears in the format mm/dd/yyyy. | I see this problem also appeared in Excel 2002 but the regfix supplied by | Microsoft Knowledge base KB835718 does not work for Excel 2003. | Please any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW TO CONVERT A FIGURE INTO TEXT IN EXCEL FILE. PLEASE LET US KN | Excel Discussion (Misc queries) | |||
| how do I convert an excel file to a flat text file | Excel Discussion (Misc queries) | |||
| Convert excel file to flat text file | Excel Discussion (Misc queries) | |||
| Opening a csv file with US date format on a Australian PC | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Hybrid Mode
