saving excel sheet as csv

[Guest]

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?

 

[Bryan Hessey]

Format the (date) column as the third (last shown) occurance of
14/03/2001

This retains the format required.

--

 

[Bryan Hessey]

That should, of course, read that in your original .xls, where you have
correct dates, set the correct format, then do the .csv save.

 

[Guest]

Hi, Thanks for the response however, not sure what you mean by the third
occurance of 14/03/2001. I've checked in the Format Cells, and can only find
the format i need in the custom category. It's when i select this format
that it changes in the CSV file to the wrong format. If it's any help i'm
using office 2000.

 

[Bryan Hessey]

In Office 2003, when I rightmouse a cell and Format Cells, then selec
Date I see a number of presented formats.

The first is *14/03/2001
the third is 14/03/2001
the Eighth is 14/03/2001

Format your original date column with that (eighth) format and it wil
retain its shape after a saveAs .csv

If Excel 2000 is very different, then copy your date to a number o
columns and format each with a variation of date format to see whic
survives the .csv save (not really scientific, but practical)

Hope this helps.

--

Hi, Thanks for the response however, not sure what you mean by th
third
occurance of 14/03/2001. I've checked in the Format Cells, and ca
only find
the format i need in the custom category. It's when i select thi
format
that it changes in the CSV file to the wrong format. If it's any hel
i'm
using office 2000.