Our users export to Excel many times a day for various tasks. The OrderNum column always includes the thousands separator, e.g. 345,222.
Is there a format option in application studio to hint to excel to format as a number without these thousands separators?
They recently added the option to turn off automatic data conversions when exporting/pasting/etc data into Excel.
If you have 365 you should see these options:
This might work for you.
Was hopeful, but didn’t make the difference. Order nums still default into Excel with a comma for the thousands…
Thanks
This has been happening to our order numbers since the beginning of the year, it’s rather irritating to constantly fix Excel column formats, we also see it in Epicor itself in some financial year fields.
I have no solution but hope you find one! 
Have you tried Extended Properties?
Enter in a format like >>>>>>9?
Epicor does helpful formatting things when you export-to-Excel. The way around that is right-click > copy all with headers, then paste into Excel. Sometimes it works better to paste-values-only (alt-control-v), and it doesn’t hurt anything so that’s a useful default habit.
I usually use copy all with headers and then ctrl v which results in salesorder numbers with commas, just tried alt-ctrl-v and unfortunately same result.
Leading. zeros is a big pain too, apparently there is a new feature in Excel that will allow this, include leading zeros. Not sure if this is fully rolled out yet.
At least for BAQs/Dashboards, I will create a calculated field for anything I want treated like a string like this:
'="' + table.field + '"'
and that will preserve the leading zeros.
You can also skip copy/paste altogether by using @amurdock’s code that pulls BAQs directly into Excel.