Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Outlook Attachments opening after several errors everytime | Setting up and Configuration of Excel | |||
Links picking up values from an older version of linked file | Links and Linking in Excel | |||
.csv file - excel 2003 | Excel Worksheet Functions | |||
cannot open an xl97 file | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |