How to Ensure Excel Uses Your SAS Formats for Number Cells
Purpose
This guide gives instructions on how to ensure Excel uses your SAS formats for number cells. This includes zip codes, ID numbers and character variables. Learn how to use the HTMLSTYLE and TAGATTR style attributes to send Microsoft formats from SAS to Excel.
Best Practice
Take a look at the PDF attached.