In SAS^® Viya^® releases earlier than 2025.08, negative currency formats are exported to Microsoft Excel files from SAS Visual Analytics reports with parenthesis (instead of a minus sign).

Starting in SAS^® Viya^® 2025.08, this behavior changed. All negative currency formats exported to Microsoft Excel files are displayed with a minus sign.

This behavior occurs when you complete steps similar to the following:

1. Within SAS Visual Analytics, create a new report.
2. Add a data source with some positive and negative currency values. (For example, Euro values.)
3. Add a List table to the report, and add data to the object. In this example, the source data uses the EuroX format. SAS Visual Analytics uses the Euro format. (Note that the same behavior occurs when using other currency formats.)
4. The values in the List table are visualized with the expected format. The negative values are displayed with a minus sign in front of them:
   
   
5. Select the List table object and click the three vertical dots button on the object’s toolbar. Then select Export ► Data.
   
6. The Export Data Window is displayed.
   
   
7. For File type, select Excel workbook (*.xlsx) to create a Microsoft Excel workbook. Then, click Export.
8. In the *.xlsx file that is created, parenthesis are used for negative EURO values:
   
   

In SAS Viya releases earlier than 2025.08, negative EURO values are displayed with parentheses in Microsoft Excel files. 

Workaround

If you want negative currency values to be displayed with a minus sign in SAS Viya versions earlier than 2025.08, do either of the following:

• Use Export ► Excel workbook instead of Export ► Data.
• For the File type, select Tab separated values (*.tsv) or Comma separated values (*.csv) instead of Excel workbook (*.xlsx) in the Export Data window:
  
• Manually edit the format in the exported Excel file.