Passing the text format using the TAGATTR= attribute is not honored with the ODS Destination for Excel. The value is displayed using Excel's General format.

Instead of using the text format to treat values as a string, the data type of the cell can be modified. Changing it to a String should provide the same functionality.

Below is an example of overriding the style in PROC PRINT, adding the text format for the variable Format. This is not honored and therefore omits the leading zero. The data type is modified to String for the variable Type, which maintains the leading zero.

data one;
   format=012345;
   type=023456;
   format format type z6.;
run;

ods excel file="c:\temp.xlsx";

proc print data=one;
   var format / style(data)={tagattr="format:@"};
   var type / style(data)={tagattr="type:String"};
run;

ods excel close;

Operating System and Release Information