Forum Discussion

tex628's avatar
tex628
Community Champion
7 years ago
Solved

Commas to dots

Is there anyone that can explain why commas are changed to dots when i change from general to text datatype? 
General Comment
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    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

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

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's avatar
tex628
Community Champion
7 years ago

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