Weird format for some exported data in excel

[takui12]

Hi guys,

I've this weird problem opening data.csv generated in powerbi, in excel.

as you could see, the first column numbers, in excel results in a weird format, even if that column properties are numbers as the others...

[v-zhouwen-msft]

Hi @takui12 ,

About your problem, after my test, temporarily can not reproduce your problem, perhaps you can use the FORMAT function to display the definition of the format of your data.

Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[takui12]

I think it happens as a mismatch of regional settings in pbi/excel, but I've tried to switch from usa/europe and I still get the same error...

[v-zhouwen-msft]

Hi @takui12 ,

I also noticed this problem, my region uses "," as the thousands separator. If changing the regional settings manually does not work.Perhaps you can refer to the following article and use the Format function with the appropriate region code to customize the formatting.

Solved: FORMAT() of numbers not using regional settings - Microsoft Fabric Community

Individual country codes:

saimana.com