Excel - Automagic

We have part numbers in our DB like "3-5779"... When you pull this up via Excel (CSV report)... Excel decides this is a date and turns it into Mar-79 or something.

Anybody else figure out a way to tell Excel to stop being so "smart"?

AS400 V5R1, XE+XU1+45ESUs, SP16, NT-SQL7 for CO

reformat the column once imported.
--- Jack_Crouch <[email protected]> wrote:
http://www.jdelist.com/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=30350


__________________________________________________


World, OW B733X and Xe

Jack,

Hi. Try this.

Instead of just double clicking on the *.CVS file created by JD Edwards, try using the excel Import Text File utility.

To do this open excel, select DATA, Get External Data, Import Text File.

Select your *.CVS file out of the Print Queue folder (Hint: You will need to change the file type selection to "All File Types").

Click the Import button. This will start the "Text Import Wizard". Click the Delimited radio button and click next.

Select Comma as you delimiter and click NEXT (Do not hit finish yet!!!).

Now, on this final screen you should have a nice picture of your file as it will appear after your import is complete. Find the column with the part number in question and highlight. From the Column Data Format box in the upper right hand corner, select the Text button. This should change the description above the selected column from "General" to "Text".

Now click finish.

Your Part numbers should now be displayed correctly.

Hope this works for you.

By the way: We are using Excel 2000. The steps may differ slightly if you are on a different version.

Good Luck!

Ken

XE SP 16
Win2000/Oracle 8.1.6.

You may have to rename the file from *.CSV to some other extension if you are using Excel 97 or lower. The import from file option did not appear until Office 2000. Therefore you have to go to the file menu, and choose open, and then select ALL FILES. If you import a *.CSV file it will just open it, however, so long as the extension is not recognized by Excel, it will prompt for Import Specs, and you can then follow the directions that where supplied by the previous reply.

Some other options might be to create an Access database with IMport Specs, and then have it export the data into Excel in the proper formats.

Good luck,

Kevin Benjamin
XE, SP15, SQL, AS400

Here is the quick way:

Change the file extension .CSV into .TXT. Then import the file to Excel and Excel's important wizard will give you a chance to format columns.

MG

G
[email protected]