Forum Discussion

Marridd22's avatar
Marridd22
New Member
3 years ago
Solved

excel data

Numerical data from ecxel are not displayed as digits. e.g. 50000123 -> 5,0E+11
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi Marridd22 ,

    According to your description, I reproduce your problem.

    Although it didn't display the expected format in Power Query, you can find it display the correct format when loaded into Power BI Desktop.

    If you still want to change the format in Power Query, you can right-click the column, then select Change Type>Using Locale

     Set it like this:

    Best Regards,
    Community Support Team _ kalyj

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

     

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

Hi Marridd22 ,

According to your description, I reproduce your problem.

Although it didn't display the expected format in Power Query, you can find it display the correct format when loaded into Power BI Desktop.

If you still want to change the format in Power Query, you can right-click the column, then select Change Type>Using Locale

 Set it like this:

Best Regards,
Community Support Team _ kalyj

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