Subject: | |
From: | |
Reply To: | |
Date: | Fri, 8 Jun 2001 16:09:21 -0700 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
What happens if you enclose the number in double quotes? In other words,
make it text when you create the .csv file.
Charles Finley
Transformix Computer Corporation
145 Vallecitos de Oro
Suite 201
San Marcos, CA 92069
(760) 736-7001
fax (760) 736-7014
> -----Original Message-----
> From: HP-3000 Systems Discussion [mailto:[log in to unmask]]On
> Behalf Of Paul H. Christidis
> Sent: Friday, June 08, 2001 3:42 PM
> To: [log in to unmask]
> Subject: OT: Excel and leading zeroes
>
>
> Fellow listers,
>
> This does have some HP3000 relevance since the data are created on our
> hp3000 969.
>
> A process creates a 'comma delimited' file on our HP and using
> JTMAIL e-mails
> it to a number of people with a '.csv' extension. The reciepient
> opens their
> file with EXCEL for verification and incorporation in some other system.
> One of the columns contains the payroll number and recently we
> begun having
> problems since a new employee was assigned a payroll number with
> a leading zero.
> Excel suppresses the leading zero and eliminates it from the file
> when the user
> saves it and forwards it on. The user would prefer not to have to set the
> columns format to 'text' and thus we are trying to find if there
> is a way of
> 'pre coding' the payroll number data, thus forcing EXCEL to recognize the
> column as 'text'.
>
>
> Regards
> Paul Christidis
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
|
|