Point as thousand seperator in (NL) excel (and comma for decimals)?

[Jaheuk]

Dear all,

I am using  PROC PRINT with ODS TAGSETS.EXCELXP  on mainframe to create an XLS.

On SAS mainframe I always use format commax15. for printing amounts in European way.

However when I download the created XLS to PC, all my amounts have comma's as thousand seperator ??!!

How to resolve this?

I tried with STYLE  like I saw in some examples but without succes?

Regards,

Herman (BELGIUM)

[art297 · Accepted solution]

Herman,  Does the follow thread provide what you need? http://communities.sas.com/message/110231

It was regarding using the commax format with proc tabulate and ods tagsets excelxp, but might contain sufficient clues.

[Jaheuk]

Using  commax15.2 did the job!!

H.