Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Format numeric field without a comma

ScottShimer
7 - Meteor

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.

10 REPLIES 10
SpencerTalbot
5 - Atom

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.

Labels
Top Solution Authors