Open .csv file

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!
 
P

Pete_UK

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
 
I

izy

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.
 
Top