aideb
asked on
Excel 2010 import is formatting column
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
example.csv
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
example.csv
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hah! That first column threw me too, at first. I thought there was something wrong with the data, seeing that the first column starts with a " quote and I first thought that this was the reason that all the data was in one column only.
Until I decided to scroll to the right. :-))
Thanks for the grade and I'm glad I was able to put you on the right track.
cheers, teylyn
Until I decided to scroll to the right. :-))
Thanks for the grade and I'm glad I was able to put you on the right track.
cheers, teylyn
ASKER
User error!
Thanks for your help