Hi:
There is an ODS PDF destination but not an "ODS EXCEL" destination. The ODS HTML destination, the ODS MSOFFICE2K destination and the ODS MSOFFICE2K_X destination all create HTML files that Excel knows how to open and render. Since ODS MSOFFICE2K and ODS TAGSETS.MSOFFICE2K_X both create Microsoft specific HTML tags, I would recommend using them instead of ODS HTML.
There is another destination called ODS TAGSETS.EXCELXP. As I said, as far as I know, there is no "ODS EXCEL" destination. Because you referred to HTMLSTYLE, that implies you are using HTML-based methods to create an HTML ASCII text file that Excel can open and render. However, without knowing EXACTLY what destination you are interested in, it is very hard to provide suggestions.
However, when I run the code below, the ODS HTML type of output does NOT use the JUST=LEFT. This does not surprise me, since ODS HTML creates W3C compliant HTML -- and NOT Microsoft compliant HTML. When I open the "Microsoft flavor" of HTML with Excel, the left justification is respected. Also, the HTMLSTYLE for leading zeroes is respected. I do NOT expect MSO-NUMBER-FORMAT to ever work with W3C flavor of HTML. PDF will not respect or use MSO-NUMBER-FORMAT -- but PDF shows the leading zeroes and does respect the simple just=l in the STYLE= override syntax.
cynthia
[pre]
data class;
set sashelp.class(obs=3);
retain x 111111;
output;
name=put(x,z8.);
output;
x + 1;
run;
ods pdf file='c:\temp\pdf_out.pdf';
ods html file='c:\temp\ht4_w3c.xls' style=sasweb;
ods msoffice2k file='c:\temp\ht_mso.xls' style=sasweb;
ods tagsets.msoffice2k_x file='c:\temp\ht_msox.xls' style=sasweb;
proc report data=class nowd;
column name age height weight;
define name / display
style(column)={just=l cellwidth=1.5in htmlstyle='mso-number-format:00000000'};
run;
ods _all_ close;
[/pre]