Change numbers from a standard form without clicking each cell - Excel

Question

I imported the csv file from MySQL, documenting part numbers and descriptions. Some of these part numbers have meanings, such as 1234567890987654321, which are then reduced by excel to 1.23e18. The problem is that I cannot request a part with this formatted data.

Now I can not go through each cell, since there are more than 28,000 of them. I converted the string to text, however this does not change the data in the cell.

The immediate task I have to solve is to delete the cells and then cancel, which gets the number in text format, but then gives me the error "number in text field".

Also, some parts have part numbers, such as 12E345, which then changes to 12000000000000000000000000000000000000000000000000- you get an image.

Very annoying ...

I would like the batch process to change all values ​​to text format, thanks in advance.

Answer 1

Instead of just opening CSV in Excel, import it using Data -> External Sources -> From Text.

You will need to first select basic things, such as a delimited format, whether the first line contains headers, a separator, etc.

In the third part of the “Text Import Wizard”, you can select the data type for each column - selecting text for your columns will probably solve the problem.