Solved

Excel 2010 import is formatting column

Posted on 2011-03-01
3
194 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:aideb
  • 2
3 Comments
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst earned 500 total points
ID: 35006103
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
 
LVL 2

Author Closing Comment

by:aideb
ID: 35006156
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
 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
ID: 35006179
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

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Get rid of EXCEL title BAR 6 33
Don't Convert Time to Time-of-Day in Mail Merge 2 22
conditional formatting 4 41
Left trim cells in column A Excel vba 2 26
Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now