Date: Mon, 25 Mar 2002 11:58:42 -0500
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Hank Daley <firstname.lastname@example.org>
Subject: Re: Please remind me ....
Content-Type: text/plain; charset="iso-8859-1"
is a formula solution for XL.
From SPSS I would output an ASCII file defining the field as text, then XL
would bring in with leading zeroes.
Such a routine could easily be automated using Access, even XL.
From: Staffan Lindberg [mailto:email@example.com]
Sent: Monday, March 25, 2002 11:03 AM
Subject: Please remind me ....
Hi listers !
I know I have seen this before in this list but cannot find it now.
I have a 1-4 digit numerical variable in SPSS. I would like to convert it
into a 4 character string variable (right justified) with leading zeros.. I
want to later export this to Excel keeping the variable with leading zeros.
I managed to fix it in SPSS with the Nw-format but after export to Excel, no
leading zeros showed.
Thankful for any help
National Institute of Public Health