How to stop Excel from converting a text string to a number in scientific notation
We imported some data from a .csv file and we want to split it to columns. The file contains products catalogue codes that are a combination of letters and numbers. Unfortunately there are some codes that contain the letter "E" between numbers. Excel recognizes this as a number in scientific notation and accordingly converts it. The only way I know to stop this behaviour is to import the file into Power Query, split it into columns and delete the last step that was automatically inserted by Power Query.