Excel doesn't remember custom date format

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

My web site uses a txt delimited file created by excel. The format of
the date column needs to be in the form of YYYY-MM-DD. If I set up a
column this way, save it and test my web site, it works. But if I
quit Excel, reopen that project and add another entry, the date
reverts to the MM-DD-YYYY format and my site no longer understands it.
Is there a setting to force Excel to remember the custom format?

Using Excel 2000.

Jack
 
Jack,

If by "reopen the project" you mean that you're opening a text file, Excel
will use the date format that it wants, not what you want.

Tell the release of Excel you're using.
 
You must log in or register to reply here.

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

Similar Threads

date 1
Date Formats 1
Losing date format when saving .csv files 10
Dates in Excel 2003 1
Excel 2002: How to make the date format uniform ? 1
Convert dates stored as text 2
Change of date format when syncing Excel 2007 to Excel Mobilw 8
Date format changes in mail merge using Excel worksheet as data 2

Back
Top