How to Ensure Excel Uses Your SAS Formats for Number Cells
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.
Take a look at the PDF attached.