https://communities.sas.com/t5/SAS-Enterprise-Guide/Format-numbers/m-p/38195#M4657 Solved :-) Message was edited by: Niclights Mon, 21 Jun 2010 07:51:13 GMT deleted_user 2010-06-21T07:51:13Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Format-numbers/m-p/38194#M4656 I suppose that there is no function in sas EG " Digit group setting" you find that in excel. 5000 will be 5 000 after you format the excel cell.<BR /> I have a code to do that in EG but does anybody know how to change the code so the code can format the number of decimals so I can get 2 decimals?<BR /> <BR /> <B>Before:</B> 5000 <B>After:</B> 5 000.00 Message was edited by: Niclights Mon, 21 Jun 2010 07:46:30 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Format-numbers/m-p/38194#M4656 deleted_user 2010-06-21T07:46:30Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Format-numbers/m-p/38195#M4657 Solved :-) Message was edited by: Niclights Mon, 21 Jun 2010 07:51:13 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Format-numbers/m-p/38195#M4657 deleted_user 2010-06-21T07:51:13Z