Converting a string to double

Usamah22

hello,

I have a string with numbers such as 1,432.22 which i want to convert to a double but when i do this using the select function the number becomes 1. I've put in a data cleanse before converting but that has removed the decimal point so i end up with 143222. How can i just get the number i want when converting to double?

Thanks

Emil_Kos

Hi @Usamah22,

You need to remove , from your numbers.

I have used this formula to make it happen:

Replace([Field1], ',', '')

To double.yxmd