I'm exporting a list from ServiceNow with number fields to Excel, but when I try to sum the columns in Excel it doesn't work. If I export to CSV and open with Excel it does work. I'm using Eureka and Excel 2013
When you say it doesn't work, what do you mean? I just ran a test where I exported some time cards from my fuji instance to xls and I was able to sum them just fine. You might try converting the format in excel to a number.
When I sum the column in the exported Excel file I get a sum of 50,000, but when I sum the same column in the exported CSV file I get the correct sum of 150,790,617.04
The field I'm having trouble with is a currency field and SN is exporting a $ at the beginning of each value. Excel seems to interpret the $ as indicating a text field which cannot be summed.
Is there a way to prevent the $ from coming through on the export?
