Open .csv file

Giganews Newsgroups
Subject: Open .csv file
Posted by:  izy (izy.28mmba_1149002401.2153@excelforum-nospam.com)
Date: Tue, 30 May 2006

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!

--
izy
------------------------------------------------------------------------
izy's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34942
View this thread:http://www.excelforum.com/showthread.php?threadid=546747

Replies