How to i convert string to double without the numbers changing

[AlteryxUser001]

Hi All in order to enter formula i need to convert string fields to numeric which I can complete using the select tool. 

however the digits in the field then suddenly lose 3 digits after the comma and become completely different numbers.

is there a way to solve this

[gautiergodard]

@AlteryxUser001 Could you please provide some sample inputs you are working with and sample desired outputs? 

[FreeRangeDingo]

If you remove the punctuation it won't remove the 3 digits after the comma.  You can remove punctuation with a Data Cleansing tool.  With punctuation, it will only be a string, not a number.  You can convert it back to a string and add commas at the end of your workflow after you are done working with numbers if needed.

[binuacs]

@AlteryxUser001 One way of doing this

[AlteryxUser001]

thanks, is there any way of doing that without the need to create  a new column - as in, can that formula be applied to the amount column in your example below

[binuacs · Accepted solution]

@AlteryxUser001 you can use the Multi-Field formula tool for that