Forum Discussion

rmx000000's avatar
rmx000000
New Member
8 years ago
Solved

scientific notation

Hi,   I have a csv file with two columns :   column A, column B 1.5554E-43, 4.2039E-45     Power BI assumes that both columns are strings. If I change them to number, it gives an error.   I...
  • rmx000000's avatar
    rmx000000
    8 years ago

    Yes, I found out that regional settings was the problem.

    I switched to ENglish (US) and the problem was solved.

     

    THank you anyway. 

rmx000000's avatar
rmx000000
New Member
8 years ago

Yes, I found out that regional settings was the problem.

I switched to ENglish (US) and the problem was solved.

 

THank you anyway. 

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi rmx000000,

Congratulations, you have resolved your issue, please mark the right or helpful reply as answer, so more members like you will get help from here. Thanks for understanding.

Best Regards,
Angelia