Alteryx excel output issue

HI team,

I have a column that contains numbers however, the file keeps showing comma separators. I don't want such comma separators so I changed it to v_string. Now it shows up without commas, however I see green triangles on each cell and also have to covert to number all the time

Please help he just have a number without comma.

Eg: 345677 not 3,456,77 and not 345677 with a green triangle

I know there's a way in excel to remove the green triangles but I still have to convert them to number which is not good.

Workflow

Help

Accepted answers

vizAlter

@henrygeorge — That means all set with Alteryx and its output in Excel.

However, your default Excel file/application is set with commas for the numbers datatype. You need to set the format in Excel.

https://support.microsoft.com/en-us/office/show-or-hide-the-thousands-separator-b9f8aee0-ef50-42e5-8fd7-6e3ab1493876

henrygeorge

@vizAlter thanks for your reply

So that means I should select all my numeric columns and change them from thousand separator and then remove the 2 zeros (cause they create a '. 00') is there no other option to have an output as such?

All comments

vizAlter

@henrygeorge — Can you attach sample data and workflow, if possible.

henrygeorge

@vizAlter i can't attach my Workflow but here are some pictures..

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703