date formatting mixed up

[Arie Bos]

I have a list of 500 dates in one column.
all of them are US locale.

Then, I used the custom format mm-dd-jjjj;@ (I am in the Netherlands, hence the J instead of Y)

Strangely enough, some cells show then as dd-mm-jjjj, and when I then choose that format, they change into mm-dd-jjjj. Still, a proper graph cannot be generated as obviously it is still a wrong format to create a graph from consecutive dates.

Is there a generic date format so I can make them all the same?

Many thanks,

 

[yky]

Copy the dates in question and paste them by value to see if they are really what you think they are. I suspect they were entered in wrong format.