Hi all, I´m trying to convert numbers storaged as V_Wstring in a csv file to a negative number. The csv format storage the negative numbers with () (ex.: (238,456,791) I tried two ways * Changing the data type from V_Wstring to Double and Float (in this case brings only the digits before the first comma) * Using the "ToNumber" formula (in this case brings the positive numbers correctly but shows a warning conversion regarding the negative ones) If any additional data or screenshot is helpful please let me know and I´ll add it Thanks a lot in advance!

Convert numbers storaged in a csv file as V_Wstring to a negative number (double)

Hi all, I´m trying to convert numbers storaged as V_Wstring in a csv file to a negative number.

The csv format storage the negative numbers with () (ex.: (238,456,791)

I tried two ways

Changing the data type from V_Wstring to Double and Float (in this case brings only the digits before the first comma)
Using the "ToNumber" formula (in this case brings the positive numbers correctly but shows a warning conversion regarding the negative ones)