Posted to microsoft.public.excel.programming

Nigel

external usenet poster

Posts: 923

CSV File - Date Formats

Hi All
I have a CSV file that contains dates held in European format (dd/mm/yyyy).
When I open it manually using Excel, the dates remain unchanged. If I open
it using VBA then the dates are changed to US format where they can... so
01/04/2005 becomes 04/01/2005. However dates that cannot be converted eg
23/03/2005 are left as is. I end up with a mixture of dates and formatting
does reset my dates to the correct format!

How can I avoid this problem?

--
Cheers
Nigel

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date Formats	david d	Excel Discussion (Misc queries)	2	September 14th 08 12:29 PM
Help with Date formats	ROn Stalenberg[_2_]	Excel Discussion (Misc queries)	1	September 10th 08 04:57 AM
DATE FORMATS	Lindsay Graham	Excel Discussion (Misc queries)	4	August 28th 08 02:17 AM
Date formats	mohd21uk via OfficeKB.com	New Users to Excel	1	May 16th 06 02:41 PM
Date formats	mohd21uk via OfficeKB.com	New Users to Excel	3	May 16th 06 01:09 PM

All times are GMT +1. The time now is 05:35 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us