Here's what I do when I deal with csv data with very long numbers.
Save the csv locally, then Date > Get Data > Legacy Wizard (From Text) > delimit by comma and then chose to set the data format as Text for the problem data.
yeah, i have a feeling the way i'm going is: save file as csv get data from csv into table from power query
@Chalfie started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
Here's what I do when I deal with csv data with very long numbers.
Save the csv locally, then Date > Get Data > Legacy Wizard (From Text) > delimit by comma and then chose to set the data format as Text for the problem data.