Forum Discussion
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
Responsive ResidentHi 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
Hi, jeroendekk as per your suggestion I used the locale option while changing the datatype and it worked. Thanks a lot for your help. đź‘Ť
