View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Johny B Johny B is offline
external usenet poster
 
Posts: 1
Default 2003 to 2000 CSV compatiblity issues

I have a 2003 excel CSV file from work that I need to open with my home copy
of 2000 excel. 2000 wont open the file so I opened it with notepad and saved
it as text hoping to simply import the base text into 2000.The problem seems
to be the way the two programs handle carraige returns within the csv. I use
alot of forced carraige returns to make HTML readable within my files. 2003
saves and reads a direct carraige return as a forced carraige return as long
as it's enclosed within the quotes. However, 2000 saves and reads the text
equivilent of a return, that little boxy character. Help?