Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
izy
 
Posts: n/a
Default Open .csv file


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...o&userid=34942
View this thread: http://www.excelforum.com/showthread...hreadid=546747

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Outlook Attachments opening after several errors everytime cito_support Setting up and Configuration of Excel 2 March 13th 06 06:15 PM
Links picking up values from an older version of linked file Cate Links and Linking in Excel 4 October 20th 05 01:53 PM
.csv file - excel 2003 giddne Excel Worksheet Functions 2 October 11th 05 05:29 AM
cannot open an xl97 file maxzsim Excel Discussion (Misc queries) 1 June 24th 05 12:29 PM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM


All times are GMT +1. The time now is 11:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"