| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Re-formatting of dates from Excel to CSV
When I save an Excel worksheet as a CSV file the dates are re-formatted from
04/11/2004 to 4/11/2004 (British style Date ddmmyyyy). This doesnt happen immediately on saving but when the CSV file is closed and then reopened. Any suggestions how I can prevent it dropping the leading zero? Many thanks GLS -- GLS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Conditional Formatting in Excel Help Please..... | Excel Discussion (Misc queries) | |||
| Auto Formatting an Excel Spreadsheet | Excel Discussion (Misc queries) | |||
| Formatting dates in the future | Excel Worksheet Functions | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
