Formating Numbers

On Tue, 5 Jan 2010 11:05:01 -0800, klafert
wrote:

I not mistaken and I am importing this into an accounting program. However,
I can't open the .csv file in Excel without the number 5280-3-01 into a date.
I am pasting how the file looks when you open it using notepad:

You are mistaken when you wrote that SAVING the file in csv format changes it.
It is NOT being changed when you SAVE the file as evidenced by what you just
pasted below! (It is being changed when you OPEN the file in Excel).


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
It looks correct there but in the .csv (excel view) :


Why do you need to open it in Excel?

I thought you wrote you were exporting it to another program?

***If you need to open it in Excel, I gave you instructions in my initial post.
--ron

Agian I am sorry for the duplicates Posting for some reason they did not show
up yesterday. I was able to view them early am today.

"Ron Rosenfeld" wrote:

On Tue, 5 Jan 2010 11:05:01 -0800, klafert
wrote:

I not mistaken and I am importing this into an accounting program. However,
I can't open the .csv file in Excel without the number 5280-3-01 into a date.
I am pasting how the file looks when you open it using notepad:

You are mistaken when you wrote that SAVING the file in csv format changes it.
It is NOT being changed when you SAVE the file as evidenced by what you just
pasted below! (It is being changed when you OPEN the file in Excel).


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
It looks correct there but in the .csv (excel view) :


Why do you need to open it in Excel?

I thought you wrote you were exporting it to another program?

***If you need to open it in Excel, I gave you instructions in my initial post.
--ron
.