How are you exporting the data?

----- Original Message ----- 
From: "Saunders, Robin" <robin.saunders@xxxxxxxxx>
To: "PC Technical Discussion for iSeries Users" <pctech@xxxxxxxxxxxx>
Sent: Tuesday, February 24, 2004 1:26 PM
Subject: RE: [PCTECH] 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.
> _______________________________________________
> 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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.