I have a real problem with Excel in csv files where it is formatting numbers in certain ways and I cannot seem to get Excel to display the data right no matter what I do.
Imagine I have a colum called "Product Reference". Within that column I have many IDs of the type:
Whenever I open the Excel file it formats these numbers to be:
Which is totally wrong. When I highlight the column and format it as text the previous 0's at the beginning of the numbers do not return.
In an attempt to solve this I even made the csv file a text file first and then imported the file into Excel and specifically told it to not format the numbers by making it text format within the import but it still formats the numbers wrong when I close it and open it again due to the fact that csv cannot define types so Excel auto saves the file as pure garbage.
Has anyone found a way around this and could help me out?