Replace ',' with '.' in a numeric value.

[Nick_Fisher]

For budget data, I would like to replace a comma with a dot and keep it as a numeric value.

While I load a Excel Sheet as the Input Data the number shows up correct (for instance 0.083721) when I run my Workflow

the output in the .csv file is shown like 8,37209E+12 while I want it to show up like 0.083721.

What should I do?

[cjaneczko]

Take a look at this article. You may want to look at Fixed Decimal.

https://knowledge.alteryx.com/index/s/article/Converting-Values-from-Scientific-E-Notation-158346017...

[Deano478]

hey @Nick_Fisher to my knowledge CSV may use scientific notation for very large or small numbers in order to reduce the number of characters in the cell/file as a whole so this may be why this happening if you save as XLSX does the same happen?

[Nick_Fisher]

Thank you for your reactions.

The Fixed Decimal definitely helped in Alteryx, the results are what I would like to see in the .csv file or even a .xlsx file. But if I view the data there it's different from Alteryx.

I would like to get the Alteryx data. But it changes during the conversion to .csv or. xlsx unfortunately.

I have added some screenshots. Alteryx has the correct way of with a dot, while Excel looks different and has a comma.

[cjaneczko]

If you open the file in a Text Editor how does it look? Does it look like it does in Excel or Alteryx? I am wondering if maybe the setting in Excel is not set correctly.