Export amounts into Excel with commas but NOT as Text

[NicoleHou]

I am using a numeric total within a file, I need the commas but when I export, I need it to not be a text field.  I need it to be numeric to use formulas on the amount after I add the commas?

[DataNath]

@NicoleHou as far as I’m aware this isn’t possible - if you want to have thousand separators then you’ll need to sacrifice the numeric data type and use the ToString() function with the thousand separators argument set to 1 for yes: https://help.alteryx.com/20221/designer/conversion-functions

[Garabujo7]

Hello @NicoleHou. You could do it selecting the output as xlsx and it keeps the thousands separator.

[MichelleL]

Hi @NicoleHou  - In an Excel file, set the formatting you want.  Then in the Output tool, save to that file and check Preserve Formatting on Overwrite (like shown below).  This can sometimes get tricky if the number of rows changes, but I've included a solution for that as well (attached).  Let me know if this works for you! :-)