I have a spreadsheet that contains the following data:

Date Account ID
5/14/08 5280-3-01
5/14/08 5280-3-01
5/14/08 5280-3-01
5/14/08 5280-3-01
5/14/08 5280-3-01
5/14/08 5280-3-01
5/14/08 1030-0-01
5/14/08 1030-0-01
5/14/08 2101-0-01
5/14/08 2101-0-01
5/14/08 2101-0-01
5/14/08 2101-0-01
5/14/08 2101-0-01
5/14/08 2101-0-01
5/14/08 2101-0-01
5/14/08 2101-0-01


When I save it as a .csv file it looks like this:

Date Account ID
5/14/2008 3/1/5280
5/14/2008 3/1/5280
5/14/2008 3/1/5280
5/14/2008 3/1/5280
5/14/2008 3/1/5280
5/14/2008 3/1/5280
5/14/2008 1030-0-01
5/14/2008 1030-0-01
5/14/2008 2101-0-01
5/14/2008 2101-0-01
5/14/2008 2101-0-01
5/14/2008 2101-0-01
5/14/2008 2101-0-01
5/14/2008 2101-0-01
5/14/2008 2101-0-01
5/14/2008 2101-0-01


I have formatted it to Text, Number, and General etc. I have Copy the data
into a new spreadsheet, cleared all formatting. Tried this on two different
computers. No matter what it keeps changing the 2nd column to a data format.
Even though it doesn’t do it to the other account ID. I have imported this
stuff before and no problem. I am not importing into Excel.

When I open the file using notepad this is what it looks like:
Date,Account ID,Reference,Trans Description,Amount,Number of
Distributions,Recur Number,Recur Frequency
5/14/08,5280-3-01,AP015843,TIPMASTER'S,-115,8,,
5/14/08,5280-3-01,AP015843,TIPMASTER'S,-115,8,,
5/14/08,5280-3-01,AP015843,AT&T ADVERTISING,-2020,8,,
5/14/08,5280-3-01,AP015843,CRYSTAL CLEAR SOLUTIONS,-1875,8,,
5/14/08,5280-3-01,AP015843,AT&T ADVERTISING,-2020,8,,
5/14/08,5280-3-01,AP015843,CRYSTAL CLEAR SOLUTIONS,-1875,8,,
5/14/08,1030-0-01,AP015843,V:1632/C:8307,"1,875.00",8,,
5/14/08,1030-0-01,AP015843,V:1632/C:8307,"1,875.00",8,,
5/14/08,2101-0-01,AP015843,AT&T ADVERTISING,"2,020.00",8,,
5/14/08,2101-0-01,AP015843,TIPMASTER'S,115.00,8,,
5/14/08,2101-0-01,AP015843,CRYSTAL CLEAR SOLUTIONS,"1,875.00",8,,
5/14/08,2101-0-01,AP015843,V:1632/C:8307,-1875,8,,
5/14/08,2101-0-01,AP015843,AT&T ADVERTISING,"2,020.00",8,,
5/14/08,2101-0-01,AP015843,TIPMASTER'S,115.00,8,,
5/14/08,2101-0-01,AP015843,CRYSTAL CLEAR SOLUTIONS,"1,875.00",8,,
5/14/08,2101-0-01,AP015843,V:1632/C:8307,-1875,8

course these are all the columns