Text to number

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.

Preparation

Accepted answers

You could use a couple formulas:

Remove the commas
Change the negative placement (if needed)
Convert to double

String to Double.yxmd

All comments

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...

You could use a couple formulas:

Remove the commas
Change the negative placement (if needed)
Convert to double

String to Double.yxmd

Quick Links

Tags

This months top contributors

Hollingsworth 335