Hello Friends,
I have been trying to convert my “Event_ID” data format to look normal. Unfortunately, I am still struggling. Here is my excel attached. When you look at column “A” some data are showing with this format “2.02E+13”. My goal is to convert the entire column A to have a similar data format. See if you can help or guide me to the right path.
Thank you in advance
AviationData.csv (18.5 MB)
Once you import the data into Power Query and change the column Data Type to Text, the formatting issue would get fixed. Hope this helps!
Hello @Cheusi,
Thank You for posting your query onto the Forum.
Well, Power Query auto-detects the data type based on the first 1000 rows and therefore, the “Event.Id” is converted into a Whole Number data type i.e., “Int64.Type”. Change this data type to “Text” and you’ll start to see the data as expected. Below is the screenshot of the final results provided for the reference -
Hoping you find this useful and meets your requirements that you’ve been looking for. 
Thanks and Warm Regards,
Harsh
