Can't sum columns in exported Excel files

[Tim Wmson]

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

[howardaustin]

Brad,

Your time sheets probably have the cost stored as a decimal rather than of type "currency."

Tim,

Currency is exported as a string when using Excel because its sys_properties.list value is a string.   I don't know what changing this value would do, so I don't recommend it.

CSV interprets the field as the Excel type "currency" because the content is not dictated by the export.   When Excel opens the CSV, it evaluates the cell for the most likely content.  

You may need to discuss the export function with HI to do what you want it to do.   In the mean time, either export to CSV, or export in Excel and convert the cells as number.   Highlight the cells, select the error popup and choose "Convert to number"

[Tim Wmson · Accepted solution]

This is a known issue:

https://hi.service-now.com/kb_view.do?sysparm_article=KB0546921

[bianca_vaccarin]

You can subscribe to the KE that Tim linked to for updates to the Workaround and fixed in sections!