Hi: You will have to send a Microsoft format from SAS to Excel. Since you are using HTML-based techniques to create a file for Excel, this points to 2 changes to your code: 1) I would recommend using ODS MSOFFICE2K as the destination instead of ODS HTML. ODS HTML destination creates HTML 4.0 "flavor" of HTML tags, which Microsoft doesn't always like. On the other hand, ODS MSOFFICE2K creates Microsoft HTML "flavor" of HTML tags (yes, Microsoft created their own flavor of HTML). 2) When Microsoft created their own "flavor" of HTML, they also created their own "flavor" of CSS style properties that you can use to send Microsoft formats to Excel. for HTML-based files, these correspond to using mso-number-format style property with the HTMLSTYLE attribute. What you need to do is tell Excel to treat your column as TEXT, not as a number (or date). So the "magic" character that does this is the @, which represents text in a Microsoft format. I show an example of this on pages 2-4 of this paper. http://support.sas.com/resources/papers/proceedings11/266-2011.pdf (look at the HTMLSTYLE override example for the ISBN variable). cynthia
... View more