SAVE AS CSV, KEEP DATE FORMAT

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
 
D

Dave Peterson

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.
 
Z

zvkmpw

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top