We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

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