creating .csv file with numeric value
GCC Consulting
gcc at optonline.net
Fri Oct 22 17:55:16 PDT 2004
> -----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
More information about the Filepro-list
mailing list