Excel extracts into a txt file

[huorsa]

I'm extracting excel files into txt files which I open in Notepad and subsequently load into an accounting database. I've noticed that when I open the file the information does not look as I have in excel.

Per example I have:

2004-11-10 Eg 1 540000010027 CH-60 1,900.00....EXPENSEES...2
2004-11-10 Eg 1 540000010027 CH-60 800.00.......SALES.........2

And when I open the txt file I get the following

2004-11-10 Eg 1 540000010027 CH-60 1,900.00 EXPENSEES 2
2004-11-10 Eg 1 540000010027 CH-60 800.00 SALES 2

I want to get the information like this:

2004-11-10 Eg 1 540000010027 CH-60 1,900.00... EXPENSEES....2
2004-11-10 Eg 1 540000010027 CH-60 800.00...... SALES..........2

Am I doing something wrong, should I use a different cell formar, or should I save the file as a different type (csv, prn)

PD I added .... so I can show my point (so the data appears in just like it appears in excel)

 

[steve case]

All three data sets are the same on the screen I'm looking at.

 

[huorsa]

Does anybody has a suggestion.......... I really need your help on this one.