| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SAVE AS CSV, KEEP DATE FORMAT
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| permanent conversion of 1904 date format to 1900 date format | Excel Worksheet Functions | |||
| How do I save date format: dd mmm yyyy as a csv file? | Excel Discussion (Misc queries) | |||
| Date format won't save...? | Excel Worksheet Functions | |||
| date format changes when I save to CSV via a macro, but not manual | Excel Discussion (Misc queries) | |||
| date format changes when I save to CSV via a macro | Excel Discussion (Misc queries) | |||
Threaded Mode
