The SAS Output Delivery System and reporting techniques

Accounting Format with Excelxp

Reply
New User
Posts: 1

Accounting Format with Excelxp

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.

Super User
Posts: 9,867

Re: Accounting Format with Excelxp

Could you transform it into TEXT and export it ?

Ask a Question
Discussion stats
  • 1 reply
  • 324 views
  • 0 likes
  • 2 in conversation