Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
170
Views
Topic starter
Hello, I have a situation, I imported a data base from excel into power query (excel) and for numbers like 1.83051E+11 with 12 characters in data source, in power query it brings me a rounded 10 characters number of 1.83051E+11. What can I do to have a not rounded 12 characters number in power query? Thank you in advance.
Posted : 23/06/2020 11:16 am
Hi Carmina,
Welcome to our forum!
Format the numbers as 'Number' so that the scientific notation isn't applied, then load into Power Query.
Mynda
Posted : 23/06/2020 7:03 pm
