hi,

i have to import a csv file into excel on a regular basis. The file contains
some data that are dates. For some reason excel insists on converting some
of the dates into m/d/y format rather than d/m/y.

I cant figure out why. Any clues anyone? does anyone have a way of
converting one format to the other?



TIA

Pete