Sending Reports To CSV

Some of our P/Ns have leading 0s which are lost when a report is sent to CSV. Is there any way to retain the leading 0?

Thanks in advance,

Mike Skibyak

If you look at the .csv file OW generates in a text editor, you will see that the leading zeros are in the file. Excel is "autoformatting" it as a number, which causes Excel to "drop" the leading zeros. If you select the column affected and play with Excel's "format->Cell" tool, you should be able to tell it to leave in leading zeros.

Hi,
I agreed with Segfaultreply, if you really want to use Excel to see all the correct value, you can use the Get External Data function in MS Excel. Its located in the DATA menu.

Hope it help.

Steven

AS 400 V4R5M0 JDE OW B7332 SP16

1. Send the output to text file
2.Start Excel
3. Open the text file . Text import wizard will start.
4. In step 3 of 3 of TIW, select the P/N column and select column data format as text
Enjoy

AW: Sending Reports To CSV

Ok, so this is not a JDE issue per se. However, it originates in a UBE
calling "automatically" Excel. Did anybody find a way how to setup Excel to
format cells into the "Text" format by default? Apparently, when called
"automatically", Excel formats cells into the "General" format, even if a
template with all cells formatted to "Text" for sheet.xlt or book.xlt has
been setup. The template apparently works only when creating / opening a new
worksheet, but not for these "automatic" calls. Is there something which
could be setup in the registry? For .csv, there is a Excel-related entry?
Any Excel or Windows experts out there?

Just asking. I agree that the data import wizard works very well.

Thank you, Nico

Nico Wohldorf

WOHLDORF SYSTEMS, INC.
25 San Miguel Avenue, Suite 2204
MPO Building, Ortigas Center
1600 Pasig City, Philippines

Direct/Voice: +63.2.633.1855, ext. 215
Facsimile: +63.2.638.5646
Cellular: +63.918.903.6411

E-Mail: mailto:[email protected]

URL: http://www.wohldorf.com

"Excellence in Integrated Management Systems"

-----Ursprüngliche Nachricht-----
Von: [email protected] [mailto[email protected]]Im
Auftrag von cuhand
Gesendet: Monday, April 29, 2002 1:59 PM
An: [email protected]
Betreff: Re: Sending Reports To CSV


1. Send the output to text file
2.Start Excel
3. Open the text file . Text import wizard will start.
4. In step 3 of 3 of TIW, select the P/N column and select column data
format as text
Enjoy
--------------------------
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=OW&Number=33588
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList One World® / XE mailing list / forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards®

+ - - - - - - - - - - - - - - - - - - - - - - - -+