An end user the other day stated that a Dynamics GP Smartlist Builder report that was not exporting data for some rows. Negative amounts were displaying #NAME? in Microsoft Excel.
To correct the issue for each Amount field I changed the properties in thge Field Optons window (Click Blue arrow next to field to open). I then unmarked the Show currency Symbol and Show Thousands Separator fields in the Display tab.