Setting a custom format may be an option. For example, if the number were
three digits long, setting a format of '000' will cause leading zeroes to
appear in the spreadsheet. Excel retains the leading zero when the file is
saved as text.
------------------------------------
Paul S. Butler, System Administrator
Data Trace Information Services LLC
(916) 797-5000

----- Original Message -----
From: "Paul H. Christidis" <[log in to unmask]>
To: <[log in to unmask]>
Sent: Friday, June 08, 2001 3:41 PM
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'.

>

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *