If you're have to create the CSV file for a different program, don't check it by
reopening it in excel.

Instead, check it by opening the .CSV file in Notepad.

(I don't know what Editplus is.)

If you're creating this file so that excel can use it again, then you can import
the file and then reformat the field the way you like.

clau wrote:

I am saving a spreadsheet where the date format was:
mm/dd/yyyy
I needed to be YYYY-MM-DD
I did that using format/custom YYYY-MM-DD.
The problem is when I save as CSV ,close, open again, the format shows:
mm/dd/yyyy
I used Editplus, didn't save the comma delimited.
Please help

--

Dave Peterson