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
LVL 2
aidebAsked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
Hello,

I cannot re-create the problem with Excel 2010. I used both File - Open and Data - From Text, specified the file as delimited, with commas, and set the third column to be text. Attached is the result. No issues with missing leading zeros. See attached.

Can you detail the steps that you are taking?

cheers, teylyn
Book4.xlsx
0
 
aidebAuthor Commented:
I worked out what was happening. As the first column was so large, I didn't see that I needed to select the 3rd column to be text. I thought every column was selected.

User error!

Thanks for your help
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.