Increase Decimal places in Excel using ODS TAGSETS EXCELXP option

[Sulabh]

Hi

I am trying to increase the decimal places in the excel output that ODS EXCELXP tagsets generate. The SAS dataset does show about 5 decimal places, however, when I exporrt it using ODS I see only 2 decimal places.

Could you please let me know which format/procedure/etc could I use to increase the decimals in the output?

[user24feb]

Try:

Data A;
  Number=123; Output;
Run;

ODS Tagsets.ExcelXP File="D:\Test.xml" Style=HTMLBlue;
Proc Report Data=A;
  Column Number;
  Define Number/Display Style(Column)={TagAttr='Format:0.00000'};
Run;
ODS Tagsets.ExcelXP Close;