SAVE AS CSV, KEEP DATE FORMAT

  • Thread starter Thread starter clau
  • Start date Start date
C

clau

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
 
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.
 
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
Click to expand...

CSV files contain values, but have no way to save formats.

If possible for your application, I'd suggest saving as an Excel file
-- even an older version.

If you really need to use a CSV file, you cold change the dates to
text values using something like
=TEXT(A1,"YYYY-MM-DD")
using the resulting text values to replace the original ones. But any
date calculations you might have would be messed up afterward. The
date-to-text can be reversed using DATEVALUE() in those calculations.
 
Back
Top