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.
... View more