I cannot figure out how to format a numeric value, then render it without the "," separators. I do not want it as a Text column, it is a record ID, but It should be numeric so Excel does warn about having numeric content is a text field.
Did this issue ever get resolved, other than changing excel settings?
I am having the same issue: when I render to an excel file my numeric variables show with thousand separators (commas) and if I change the number to a string, they show with the green triangle "number stored as text" error in excel). Since I plan to have numerous outputs sent to numerous business partners, changing an excel setting is not ideal.
User | Count |
---|---|
52 | |
27 | |
25 | |
24 | |
21 |