That didn't work exactly. I can get it in .xls I need to have in the .csv
file so I can import the data. I have before with no problems using this
account number. I don't have to open the .csv I just have to import it into
another program not Excel.

"Jacob Skaria" wrote:

--In 2007 from menu DataFrom Text and in 2003 from menu DataImport External
DataImport Data ---select the .csv file to be opened.

--From the 'Text Import Wizard' Step 1; select 'Delimited' and hit next

--From the 'Text Import Wizard' Step 2; select 'Comma' and hit next (you can
uncheck the other defaults selected)

--From the 'Text Import Wizard' Step 3; From 'Data Preview Area' select all
the columns which you would want to be displayed as text. In your case
Column2. Once selected the background will be black and the text will be
white.

--Then on the same window from the group 'Column Data format' select Text
and Hit Finish.

--
Jacob


"klafert" wrote:

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