Accounting Format with Excelxp

JudyL — Wed, 17 Feb 2016 13:48:39 GMT

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.

Re: Accounting Format with Excelxp

Ksharp — Thu, 18 Feb 2016 02:21:27 GMT

Could you transform it into TEXT and export it ?

topic Re: Accounting Format with Excelxp in ODS and Base Reporting

Accounting Format with Excelxp

Re: Accounting Format with Excelxp