How to change Text to Decimal Number datatype without altering the values

Hi VivekDI 

Your system probably has comma's as decimal seporator instead of periods.

3 ways to solve this when dealing with US style data.

1. you could use the replace values option on the transform tab in Power Query to replace periods with comma's before changing the data type.
2. When changing the datatype choose the locale option and then say its a decimal but with united states formatting. (This option is very helpfull when importing dates with mm/dd/yyyy format into a system with diferent settings.
3. Change the settings of your machine. But this will effect al lot of other programs as well.

Best regards,
Jeroen Dekker