| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Losing date format when saving .csv files
I am exporting accounting data out of legacy database into .csv file format.
The text data is not delimited, so I use Text to Columns and set the date fields to Text (from General). The date formats retain formatting (in my case, mm/dd/yyyy). I save the file as a .csv. When I reopen the file, I lose the date formatting. The date fields revert to m/d/yyyy. I have to use .csv file in order to upload to a 3rd party. What can I do to retain the mm/dd/yyyy format when saving as a .csv file? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenating a Text and a Date without losing orginal Date Format | Excel Discussion (Misc queries) | |||
| Losing Cell Protection When Saving Workbook | Excel Discussion (Misc queries) | |||
| How do I change date format without losing data? | New Users to Excel | |||
| saving dbf file without losing data | Excel Discussion (Misc queries) | |||
| Losing conditional formatting when saving | Excel Discussion (Misc queries) | |||
Threaded Mode
