Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
The Expert Exam is now live online! Read about the specifics and what it took to bring it to life in the blog by our very own Elizabeth Bonnell!
SOLVED

Formatting number with commas and decimals

Highlighted
8 - Asteroid

But this makes the numbers as strings right? Then can it still be calculated as numbers when exported to excel?

Highlighted
12 - Quasar

How could we do the reverse of this? From String to Number with the same formatting?

Highlighted
5 - Atom

AL-t-E-ry-X - I can see with the Browse tool that my table(s) are formatting these correctly, with the 2 decimal places and automatically placing the commas.  But, then when I try to use the Summarize tool and output to an Excel file, the number fields again are unformatted when I open the Excel file.

Highlighted
7 - Meteor

Doing any further calcs to the numbers will cause them to revert back to being unformatted. I would try the summarize and then but the values into the table tool. 

You'd then need to use a render tool to output the formatted numbers into an excel doc.

Labels