Text to number

[BautistaC888]

Hello,
I have a table with numbers in text format and i need to transform then into double number format.

I tried using the select tool with formulas but that truncated the information.
I share you an example workflow.
Thank you.

[apathetichell]

I wasn't sure if the first entry was supposed to be negative so I showed you two ways - first way doesn't account for trailing ("-") - second way counts those as negatives.

The commas are just an option under user settings/localization...

[mmish · Accepted solution]

You could use a couple formulas:

1. Remove the commas
2. Change the negative placement (if needed)
3. Convert to double