Runrigger
asked on
CSV files - Import in to Excel
Guys, having a couple of problems opening a CSV file in Excel for the following value;
1-1
the value actually means "one to one" and not "1 minus 1" and when opening, Excel translates the value to 01-Jan
I actually want the vale 1-1 to appear in the cell.
I thought that using text qualifiers would help, e.g. in the csv file, the value is "1-1" but Excel still treats this as a date value and converts to 01-Jan.
Any thoughts on how I could change way Excel acts?
1-1
the value actually means "one to one" and not "1 minus 1" and when opening, Excel translates the value to 01-Jan
I actually want the vale 1-1 to appear in the cell.
I thought that using text qualifiers would help, e.g. in the csv file, the value is "1-1" but Excel still treats this as a date value and converts to 01-Jan.
Any thoughts on how I could change way Excel acts?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If it's Excel 2010 you don't have an import function - you have to choose Open.
roybridge:
That is completely false!
Visit http://blogs.office.com/b/microsoft-excel/archive/2010/06/10/importing-text-files-in-an-excel-sheet.aspx for verification
That is completely false!
Visit http://blogs.office.com/b/microsoft-excel/archive/2010/06/10/importing-text-files-in-an-excel-sheet.aspx for verification
Sorry what I was trying to say is that there isn't a File->Import function as in earlier version of Excel. I should have been a bit clearer.
For clarification on the Data Ribbon, the "From Text" button is what you need t oimport csv using the wizard.
A>
A>
ASKER
Guys, thank you all. Import was the way to go.
Majority of points to SubversiveArmadillo as that was the most comprehensive solution
Majority of points to SubversiveArmadillo as that was the most comprehensive solution
No worries - glad to help.