Importing and Exporting to CSV file and maintaining data types

We have an Excel file that contains Loan Numbers and loan
data.  The
Loan Numbers often have leading zeros.  The data type of the
loan number
in Excel is a text string.
 
We are finding when we export to a .csv and also reimport
from a .csv,
that the Loan Numbers become numeric values and lose the
leading zeroes.

 
Any thoughts on work-arounds to maintain the text data
type?
 
Thanks
 
Jeff Junkermeier
GMAC ResCap
 

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

Jeff,

I have created a user form and accompanying macro that
prompts the user
to identify the location of the CSV files.  The macro then
populates the
form with checkboxes for each CSV file found in that
location.  Once the
user marks which files to open, each is opened with the
columns
identified as text (thus preserving the leading zeroes).  If
you are
interested, I will send you the file off list.

Paul Koch 

-----Original Message-----
From: MS Excel General Q & A List [mailto:EXCEL-GPEACH.EASE.LSOFT.COM]
On Behalf Of Junkermeier, Jeff
Sent: Wednesday, February 28, 2007 3:37 PM
To: EXCEL-GPEACH.EASE.LSOFT.COM
Subject: Importing and Exporting to CSV file and maintaining
data types

We have an Excel file that contains Loan Numbers and loan
data.  The
Loan Numbers often have leading zeros.  The data type of the
loan number
in Excel is a text string.
 
We are finding when we export to a .csv and also reimport
from a .csv,
that the Loan Numbers become numeric values and lose the
leading zeroes.

 
Any thoughts on work-arounds to maintain the text data
type?
 
Thanks
 
Jeff Junkermeier
GMAC ResCap
 

------------------------------------------------------------
------------
--
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info and
archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

There was a discussion of a very similar topic just last
week....
http://peach.ease.lsoft.
com/scripts/wa.exe?A2=ind0702c&L=excel-g&T=0&F=&
amp;
S=&P=10127

Subject: Replace Converting Text into Numbers

David

-----Original Message-----
From: MS Excel General Q & A List [mailto:EXCEL-GPEACH.EASE.LSOFT.COM]
On Behalf Of Junkermeier, Jeff
Sent: Wednesday, February 28, 2007 5:37 PM
To: EXCEL-GPEACH.EASE.LSOFT.COM
Subject: Importing and Exporting to CSV file and maintaining
data types

We have an Excel file that contains Loan Numbers and loan
data.  The
Loan Numbers often have leading zeros.  The data type of the
loan number
in Excel is a text string.
 
We are finding when we export to a .csv and also reimport
from a .csv,
that the Loan Numbers become numeric values and lose the
leading zeroes.

 
Any thoughts on work-arounds to maintain the text data
type?
 
Thanks
 
Jeff Junkermeier
GMAC ResCap
 

------------------------------------------------------------
------------
--
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info and
archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G