Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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