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

Workflow

Tips and Tricks

Transformation

Accepted answers

binu_acs

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

ToNumber_1128.yxmd

All comments

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.

binu_acs

@AlteryxUser001 One way of doing this

ToNumber_1128.yxmd

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

binu_acs

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

ToNumber_1128.yxmd

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335