Open .csv file

  • Thread starter Thread starter izy
  • Start date Start date
I

izy

Hello,

I am opening a .csv file with Excel. I have some series of data that
are formated like:

6-1
12-7
3-1
etc..

When it opens with excel it changes these to a date like:
1-Jun
7-Dec
1-Mar

And when I try and change the format of these cells back to general
text it has some strange number like:
38869
39058
38777

Is there any way to stop excel from converting this data to a date when
opening the csv file?

Thanks!
 
If you change the extension to the file from .csv to .txt and then use
File | Open in Excel, then you will be taken directly into the Text
Import Wizard where you will be able to specify in the third dialogue
box that you want this column of data to be imported as Text rather
than as General.

Hope this helps.

Pete
 
When I opened as a text file no wizard started. It just put all the text
into one cell.

Anyways, I ended up changing the data from "6-1" to "6 to 1"

I wish there was a way to turn off the auto formatting within excel. I
gets very annoying at times.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CSV->Excel Data Problem 1
Excel CSV Files; Creating Of 3
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Open csv file with Leading Zeros 1
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Import Multiple CSV Files from Same Folder into Open Workbook 5
csv files 1
Add csv to Open "All Excel Files" (XL2007) 3

Back
Top