https://communities.sas.com/t5/ODS-and-Base-Reporting/Excel-exporting-with-2-decimals-for-all-values/m-p/50938#M6494 Found it...!!!!<BR /> <BR /> define trans_amount / display "Transaction Amount" format=12.2 style(column)={tagattr="format:##0.00" outputwidth=1in };<BR /> <BR /> or<BR /> <BR /> call define(_col_,'style','style={tagattr="formula:R[-1]C+RC[-2] format:##0.00"}'); Fri, 15 Apr 2011 12:05:14 GMT SanjayM 2011-04-15T12:05:14Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Excel-exporting-with-2-decimals-for-all-values/m-p/50937#M6493 I am using the following code to export data into excel.<BR /> The excel also has formulas added which I have ignored in this example.<BR /> <BR /> I need some help in outputting the values consistently with 2 decimals for numeric columns and values. <BR /> ods listing close;<BR /> <BR /> ods tagsets.excelxp file="&amp;rep_filename."<BR /> <BR /> <BR /> ods tagsets.excelxp file="&amp;rep_filename."<BR /> style=styles.printer<BR /> options(embedded_titles='yes' sheet_interval='none' <BR /> width_fudge='0.75' sheet_name="&amp;customer_number"<BR /> default_column_width="10,0,8,8,8,8,8,8,8" FitToPage = 'yes' PAGES_FITWIDTH = '1' Pages_FitHeight = '100')<BR /> ;<BR /> ods tagsets.excelxp options(embedded_titles='yes' <BR /> sheet_interval='none' sheet_name="&amp;customer_number" FitToPage = 'yes' PAGES_FITWIDTH = '1' Pages_FitHeight = '100');<BR /> <BR /> proc report data=mps18_final;<BR /> columns cntrows trans_eff_date code description account_number<BR /> trans_amount <BR /> col_bc <BR /> arrears_bal_for; <BR /> <BR /> define cntrows / computed noprint;<BR /> define trans_eff_date / display "Transaction Date" center style(column)={outputwidth=1.2in just=center};<BR /> define code / display "Code" center format=$10. style(column)={outputwidth=0.70in just=center};<BR /> define description / display "Description" format=$100. style(column)={outputwidth=2in};<BR /> define account_number / display "Sub Account Number" center format=10. style(column)={outputwidth=1in just=center};<BR /> define trans_amount / display "Transaction Amount" format=12.2 style(column)={outputwidth=1in };<BR /> define col_bc / display "Account Balance" format=12.2 style(column)={outputwidth=0.70in};<BR /> define arrears_bal_for / computed "Arrears Balance" format=12.2 style(column)={outputwidth=0.70in};<BR /> run;<BR /> <BR /> I have just provided a sample of the code and not the entire code Fri, 15 Apr 2011 10:36:03 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Excel-exporting-with-2-decimals-for-all-values/m-p/50937#M6493 SanjayM 2011-04-15T10:36:03Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Excel-exporting-with-2-decimals-for-all-values/m-p/50938#M6494 Found it...!!!!<BR /> <BR /> define trans_amount / display "Transaction Amount" format=12.2 style(column)={tagattr="format:##0.00" outputwidth=1in };<BR /> <BR /> or<BR /> <BR /> call define(_col_,'style','style={tagattr="formula:R[-1]C+RC[-2] format:##0.00"}'); Fri, 15 Apr 2011 12:05:14 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Excel-exporting-with-2-decimals-for-all-values/m-p/50938#M6494 SanjayM 2011-04-15T12:05:14Z