Forum Discussion
The annoying excel scientific notation
I have a column which is the supplier item code, it contains text or a long barcode (so it is not pure long "number" barcode), e.g. ABC123456 1000000000000000 The data are from some source th...
#1 The data are from some source that I cannot control What kind of Source is it (Csv/text file,...)
#2 What version of Excel do you run?
#3 On which platform/OS (Windows, Mac...)?
Depending on the above you might have a solution with Get & Transform aka Power Query:
In attached file query ExternalSource simulates an external data source, query ImportedData just transform the data types as desired (Text for Barcode)
+ Feel free to UpVote https://feedbackportal.microsoft.com/feedback/idea/45e412a2-513b-ed11-9db0-000d3a4e3f39