creating .csv file with numeric value

[Dennis Malen]

Richard,

Thanks for the response.

I am trying to avoid manual intervention and not have someone go in
manually. The problem is I am creating the file on a UNIX box which then
sends the file either to our windows server or to a client. I don't want to
have the client manually fix the column and I don't want to send it to
windows and fix it before it is sent. That would be contrary to our intent
to do this in an automated fashion.

Dennis

----- Original Message -----
From: "GCC Consulting" <gcc at optonline.net>
To: "'Dennis Malen'" <dmalen at malen.com>; <filepro-list at lists.celestial.com>
Sent: Friday, October 22, 2004 8:55 PM
Subject: RE: creating .csv file with numeric value


>
>
> > -----Original Message-----
> > From: filepro-list-bounces at lists.celestial.com
> > [mailto:filepro-list-bounces at lists.celestial.com] On Behalf
> > Of Dennis Malen
> > Sent: Friday, October 22, 2004 2:29 PM
> > To: filepro-list at lists.celestial.com
> > Subject: creating .csv file with numeric value
> >
> > My problem is as follows:
> >
> > I created an export file which is a comma delimited and the
> > processing then adds the extension .csv
> >
> > This is created on a unix box and then ftp'd to windows.
> >
> > Once I double click on the file in windows it is
> > automatically loaded into excel perfectly. This is not the problem.
> >
> > PROBLEM
> >
> > One of the columns is a social security number. Some of the
> > numbers have a leading zero (0) before it was loaded. Because
> > all of the columns in Excel are defined as "general" as
> > opposed to "text", the leading zero(0) is deleted when it is loaded.
> >
> > Does anyone know how to solve this problem without having to
> > manually import the file into excel and manually change the
> > definition of the file from "general" to "text".
> >
> > If the column is defined as "text" then the leading zero (0)
> > is retained.
> >
> > Dennis Malen
> > 516.479.5912
> Dennis,
>
> 1. Click on the column letter to select all the row in the column
> 2. Right click with the mouse pointer over on of the cells
> 3. Select format Cell
> 4. Select Special
> 5. Select Social Security Number
>
> Your leading zero will be added back in.
>
> If you need to do this often enough, you could create a macro to run once
the
> sheet is opened to do this for you.
>
> However, this takes seconds to do manually.  It probably took you longer
to read
> the instructions then to execute the steps.
>
> Richard Kreiss
> GCC Consulting
>
>
>
>