RE: Exprting data into Excel drops leading zero

Hi Dennis,

There was a recent discussion about this in the Midrange list. Hope this
link will help.

http://archive.midrange.com/midrange-l/200402/msg00512.html

Regards
Robin

-----Original Message-----
From: Dennis Munro [mailto:DMunro@xxxxxxxxxxxxxxxxxxxx]
Sent: Wednesday, February 25, 2004 1:50 AM
To: 'PcTech@xxxxxxxxxxxx'
Subject: [PCTECH] Exprting data into Excel drops leading zero


W2K Pro SP4  -  Office 2000
 
When I export data from the 400 into Excel:
1-       numeric values are shown with the leading zero(s) dropped in a cell

2-       if the number has only zeros after the decimal point, they also are
dropped but that can be changed by formatting the cell
3-       when exporting a column defined as character that has only numbers,
all leading zeros are dropped
 
When I export the same data into a csv or tab delimited file & view that via
Word Pad, the zeros are there & numeric values also show the correct number
of places after the decimal point.
 
So, what can be done to keep all the zeros in place when exporting into
Excel?  Formatting the cell as text does not bring the dropped leading zeros
back.
 
Thanks - Dennis.
 
Dennis Munro
 
"I love deadlines. I especially like the whooshing sound they make as they
go flying by."
Dilbert's Words Of Wisdom
 
Badger Mining Corporation
www.badgerminingcorp.com
dmunro@xxxxxxxxxxxxxxxxxxxx
(920) 361-2388   Ext.141
 
The information contained in this e-mail message is confidential information
intended only for the use of the individual or entity named above. If the
reader of this message is not the intended recipient, or the employee or
agent responsible to deliver it to the intended recipient, you are hereby
notified that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this
communication in error, please immediately notify us by telephone, and
return the original message to us at the below address via the U.S. Postal
Service, and delete it from your computer.  Badger Mining Corporation  P.O.
Box 328  Berlin, WI 54923  920-361-2388
_______________________________________________
This is the PC Technical Discussion for iSeries Users (PcTech) mailing list
To post a message email: PcTech@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/pctech
or email: PcTech-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/pctech.