converting a Number field from V-String to Double and losing data

[cstafford]

I have a .txt file that has a quantity column in it. When I attach the select tool to the input file, the quantity column comes in as V-String and has negative values. When I change the data type to Double, I lose the negative values and large values that have commas are lost; for example, 1,320 becomes 1. I reverted the field back to V-String and used Mutli-Field Formula to replace the comma in the number and changed the output type to Double, which looked to work but I still loose the negative values. I could just keep the data type as a V-String, but since it is a quantity column, I would like to have it as a number. Any suggestions?

[aatalai]

@cstafford  trying removing the ",2 first and then using a select to convert it to double, I've attached a workflow for reference 

[cstafford]

I am still losing the negative values. I keyed in 1,320- an 210- and it converts to 1320 and 210. Any ideas how to keep the negative values?

[binuacs · Accepted solution]

@cstafford 

[cstafford]

This solved the issue with the negative values. Thank you!