Hello,
I need to output a number with a comma as the decimal separator. I transformed the number and overwrote the file, but when I do that, Excel shows the cell as a text value (see attached file).
If I output it in number format, it keeps the “,” symbol, which I need to avoid.
Thank you.
@BautistaC888
If you want that the output will be a number use period (.) as the decimal separator. The funny thing with Excel is that numbers will change based on the user setting. If the user is in Europe and it is set for European numbers it will be comma, if it is set for American format it will be period.As Alteryx is using period as the decimal separator you need to use it as default. If I remember correctly when you will open the file then excel will select comma or period to define the value as number. So the minute that you will sent a number in Alteryx with comma it by default will change to string.
@OTrieger is correct and that is how I understand it also. If you need the output, say in a CSV format to retain the commas instead of periods... then allow Alteryx to treat the numbers in its natural format and the last thing you do then is convert using a formula tool to the desired format.
But if you're just going into Excel then let Excel handle it when it reads the data using the users default settings for number display. -Jay
