Thank you Reeza,RW9 & Cyntia for your patience and support.Sorry for getting back late It worked and in the format the only modification was adding comma after the 0 in the format which worked.   style={tagattr="Format:[$$-409]#,##0,"}    ... View more

NOTE: This is the Excel XP tagset (Compatible with SAS 9.1.3 and above, v1.131, 04/23/2015 ... View more

Thanks for your patience and support. The output is not displayed in 000 fomat.I want the amounts in milion to be displayed in 000 format .When the user clicks he can see the whole value   I attached screen shot of output   Data Dolr_test; input Agent $ Dolrs 15.2; datalines; George 31918175.55 Adam 9013533.98 Danny 59407.72 ; run;   ods tagsets.excelxp file = "C:\Dolr_test.xml" ; proc report data=Dolr_test split='*' ; column Agent Dolrs; define Agent/ order order=data; define Dolrs / display " $ Dollars * (000)"  style(column)={tagattr="Format:$###,###"}; run; ods tagsets.excelxp close; ... View more

Thanks for your patience and support.Unfortunately it didn't work. I attached the output screenshot   Data Dolr_test; input Agent $ Dolrs 15.2; datalines; George 31918175.55 Adam 9013533.98 Danny 59407.72 ; run;   ods tagsets.excelxp file = "C:\Dolr_test.xml" ; proc report data=Dolr_test split='*' ; column Agent Dolrs; define Agent/ order order=data; define Dolrs / " $ Dollars * (000)" style={tagattr='format="[$$-409]#,##0"'}; run; ods tagsets.excelxp close;   I tested but it didn't work. I attached the output how it displayed.   I want to display the amount in millions in thousands (000) format but when the user clicks on it he can see the whole value         ... View more

Hey   Sorry if you misunderstood my question   What i am expecting is if i format $xyz to display without decimals or formatting the million to display as thousands(000) format it should display in the cell with that format but when the user clicks on the cell he should able to see the full value with decimals   I attached shot of what i am expecting ... View more

Hi Reeza,   I used tagttr format.It displays the cells in formatted value. What I am trying to achieve is the excel should show the formatted value but when i click on the cell it should show full value.   I want to achieve this with out changing excel setting manually ... View more

Hi Thanks for the reply you are right.   When i export the data to excel it displays the formatted value.   The thing i am trying to achieve is it should display values in format but when i click on the cell it show full value.     ... View more