View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Date format from excel to CVS file wont. Change in CVS wont stay.

Don't reopen in Excel.

Try opening the *.CSV file in Notepad or other text program.

What happens in that case?


Gord Dibben MS Excel MVP

On Fri, 13 Oct 2006 08:54:01 -0700, Fish''s Mermaid
wrote:

Changing date format in Excel and then saving to CVS file. Change won't
transfer to CVS and when changed in CVS won't stay when file is reopened.