I wrote a new P&L in ARM with expense rows coded to show as negative. It works correctly in the report, but when exported to Excel I have the problems below:

1. Amounts appearing as positive in Excel but negative in the formula bar (i.e. Excel treating as negative but appears as positive)
2. Amounts appearing as positive when they are actually negative (opposite of #1)
3. Amount showing as negative in both Acumatica and Excel (correct) but in formula bar it’s actually pulling through as a positive number

Basically the negatives are all wrong in Excel, but not consistently so  I’ve looked extensively online and in the community but haven’t found a solution. An example of the row format is below:

Appreciate any help!