Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
68
Views
Topic starter
I have an excel dataset that I obtain from Twitter. In my excel file I have a column of numbers which are called "Imported ID" each number starts with a '1296940448943090000 and is 19 digits long. When I import the table into power query the format of each number changes to 1.29694E+18. I have tried changing it to a whole number and nothing happens. This number is what I use to identify a unique tweets and is the bases for removing duplicate tweets.
My question
1. why does this occur
2. Will it affect the integrity of the 'delete duplicates' function?
Posted : 22/01/2021 10:41 pm
Hi Elisabeth,
Excel can read 15 digits, longer strings needs to be formatted as text, not numbers.
Posted : 22/01/2021 10:53 pm
