RE: Leading 0's in a CSV file

["Jonathan Mason" <jonathan.mason@xxxxxxxxxxxxxxxx>]

It's how Excel interprets it.  You need to create the column in your CSV
file as a text field, that way it will be enclosed in double quotation marks
and will be treated by Excel as a text field with the leading zeros
retained.

All the best

Jonathan

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Smith, Mike
Sent: 19 November 2004 20:47
To: midrange-l@xxxxxxxxxxxx
Subject: Leading 0's in a CSV file


I have a database file that has a character field that contains numeric
data(part#)  example 0006075.
I have created a CSV file and this particular record looks
like"0006075", but when it is opened(through EXCEL)  it shows as 6075.
I have tried putting a single quote at the beginning of the field like
"'0006075'.  However, this shows  with the single quote.
Does anyone know how to make the leading zeros appear?

Michael Smith
iSeries.mySeries.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.