Forum Discussion
tex628
Community Champion
Community ChampionCommas to dots
Is there anyone that can explain why commas are changed to dots when i change from general to text datatype?
Hi tex628 ,
In your locale, for a general value, comma works as thousand delimiter. When you changed data type to text, it used dot as text delimiter.
Regards,
Yuliana Gu
2 Replies
v-yulgu-msftMicrosoft Employee
Hi tex628 ,
In your locale, for a general value, comma works as thousand delimiter. When you changed data type to text, it used dot as text delimiter.
Regards,
Yuliana Gu
- tex628
v-yulgu-msftThank you for the help! I did not know that you had to assign locale in dataflows aswell. It appears that it defaulted to US locale which was the issue.
/ Johannes
