Alteryx excel output issue

[henrygeorge]

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. 

[vizAlter · Accepted solution]

@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-8...

[henrygeorge · Accepted solution]

@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?

 

[vizAlter]

@henrygeorge — I think so...if you want the numeric data type.

(another example: It seems that your col A has a date field, and Alteryx has YYYY-MM-DD date format. However, your screenshot from Excel sheet shows that date is in DD-MMM-YYYY format)

It is because your default date and time format of your PC.

You can change these settings anytime (in "Control Panel" >>> "Region" section), then your default Excel will also follow the same format. Make sure you google or Youtube etc. before making any changes (it's very simply)

If it resolves your query Please mark it "Solved" or "Solved" with a Like. This will help other users find the same answer/resolution.  Thank you.