Accounting Format with Excelxp

[JudyL]

I am using SAS 9.3.

How do I tell Excel to use the Accounting format (left justify the $ sign) rather than the Currency format (floating $ sign) using Excelxp tagset  and ODS?

I tried using the following, which I got from following the instructions about saving an Excel sheet as xml, but it did not left justify the $ sign.

var var1 / style={htmlstyle="mso-number-format:'_\(\0022$\0022* \#\,\#\#0_\)\;_\(\0022$\0022* \\\(\#\,\#\#0\\\)\;_\(\0022$\0022* \0022-\0022??_\)\;_\(\@_\)'"};

Thanks.

[Ksharp]

Could you transform it into TEXT and export it ?