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 · Accepted solution]

Hi @Usamah22,

You need to remove , from your numbers.

I have used this formula to make it happen:

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

[Coakles]

This worked for me! but why? why do you have to remove the comma? @Emil_Kos