I am importing a CSV file into Excel 2010 as text.
When I import, I choose that I want to take it as text so that the numbers remain the same e.g. 0005 is imported as 0005.
The import however is losing the zeros and importing 5 into the column.
I have ensured that I have the import setting to text and have also set the column properties to text but it still loses the zeros.
I have uploaded a section of the file I am uploading. The line foto 0005 is an example