Date:         Wed, 10 Oct 2001 12:08:54 -0700
Reply-To:     "William W. Viergever" <wwvierg@ATTGLOBAL.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "William W. Viergever" <wwvierg@ATTGLOBAL.NET>
Subject:      Re: SAS ODS HTML to EXCEL
Comments: To: mdurbin@erac.com
In-Reply-To:  <75ADFA77F338D411B4D900508BCFE7BE05900227@EXCORP01>
Content-Type: text/plain; charset="us-ascii"; format=flowed

At 01:22 PM 10/10/2001 -0500, Mike Durbin wrote:
>All,
>
>   I have successfully been able to use the ODS HTML output to open in EXCEL
>by using .xls as the extension of the file produced.  However, when there is
>a field with leading zeros EXCEL drops these.


Drop the value entirely *or* just the leading zeroes?

If the latter, then you'll need to apply an Excel format to that column,
e.g., if the data value has max length of 8, then apply a custom numeric
format (00000000) to that column in Excel.

If the former, call Koen <vbg>.

HTH


>  Is there anyway to remedy
>this behavior?
>
>Thanks in advance for your support,
>
>Mike Durbin

------------------------------------------------------------
William W. Viergever          Voice  : (916) 483-8398
Viergever & Associates        Fax    : (916) 486-1488
Sacramento, CA 95825          E-mail : wwvierg@attglobal.net
------------------------------------------------------------