Hi:
Wouldn't be nice if there was a simple style override that allowed you to specify a Microsoft format for numbers? Really nice?
Wait a minute. There is a simple style override that you can use with both TAGSETS.EXCELXP and ODS EXCEL. It is the TAGATTR style override, as shown below:
You can apply the $ format to the original numeric variable, as shown in the code, without needing to make a character variable and you can get rid of the decimal places. All in one simple Microsoft format. No need to reverse engineer the XML at all. I did an explicit right-justify on the character variable and an explicit center justify on the numeric variable. But as you can see, they have the SAME format in the Excel sheet.
... gotta love the ODS developers!
Cynthia
... View more