Excel doesn't remember custom date format

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
 
E

Earl Kiosterud

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