Date: Tue, 18 Jun 2002 16:18:23 -0400
Reply-To: "Goldman, Brad (AT-Atlanta)" <Brad.Goldman@AUTOTRADER.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Goldman, Brad (AT-Atlanta)" <Brad.Goldman@AUTOTRADER.COM>
Subject: Re: .csv --> Excel ..leading zeros dropped
Content-Type: text/plain; charset="iso-8859-1"
Three posters came up with the answer...
="00230" in a .csv file will resolve correctly as 00230.
I am coding it as
zip= '='||quote(trim(zip));
it works perfectly.
Thanks to all who helped.
-Brad
|