LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (June 2002, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


Back to: Top of message | Previous page | Main SAS-L page