| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
saving excel sheet as csv
Hi, I'm trying to save an excel file (xls) as a csv file. However once it's
saved and i re-open the csv file in excel the column containing dates change from dd/mm/yyyy to mm/dd/yyyy. Even if i then try to select the column of dates and change it in the format cells menu it still wont change to uk format. I've checked the main system settings which is uk format so that can't be the problem. Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Saving Excel sheet as a semicolon delimited file (.csv) | Excel Discussion (Misc queries) | |||
| Excel practice sheet. Can't view instructions. | Excel Discussion (Misc queries) | |||
| Saving Excel Sheet | Excel Discussion (Misc queries) | |||
| Opening and saving Excel 2003 file from Excel 97. | Excel Discussion (Misc queries) | |||
Threaded Mode
