Problem formatting dates from CSV file

[rhhince]

I have a problem. Every date from day 13 to day 31 refuses to convert to date format when opening CSV file in Excel 2003. Any help would be appreciated.
Thanks.


8/3/05 21:15
7/3/05 22:20
13/03/2005 19:03:00
9/3/05 22:19
9/3/05 22:00
10/3/05 19:29
13/03/2005 18:01:00
6/3/05 18:16
14/03/2005 22:17:00
8/3/05 18:21
8/3/05 18:20

 

[Claus Busch]

Hi,

Am Sun, 9 Mar 2014 00:03:11 -0800 (PST) schrieb rhhince:

I have a problem. Every date from day 13 to day 31 refuses to convert to date format when opening CSV file in Excel 2003. Any help would be appreciated.

instead of opening the file open Excel and import the file. In step 3 of
the import assistent choose for your column "Date" and the correct date
format.


Regards
Claus B.

 

[William B. (Billby)]

Another way to deal with this problem is to change your file extension type from .csv to .txt
Then when you load the file into Excel you will be presented with options:

Delimited or fixed. Select delimited with a coma "," deliminator for your previously csv files

Next you may select the DATA FORMAT for every column.

Highlight your date column and select Date and the DMY format that you require from the drop down menu.

This method takes a lot longer to describe than to actually do once your file has been renamed as a
..txt file.

In effect you are doing the same thing as Claus described by importing the file.
Except that the prompts happen automatically whenever you load a .txt file.