I have a bunch of dates which are in the format dd/mm/yy.

Unfortunately excel is reading them as mm/dd/yy. If I try to change the format to dd/mm/yy using Number Formats, it flips the dd and mm around as well.

For example: I have the following short format dates which are supposed to represent 2nd to 9th of September 2013, but are unfortunately being read by excel as the 9th of February to September.

Cell Text
2/9/2013
2/9/2013
3/9/2013
4/9/2013
5/9/2013
6/9/2013
6/9/2013
8/9/2013
9/9/2013

And if I change the format to UK dates, then the values get swapped around to
09/02/2013
09/02/2013
09/03/2013
09/04/2013
09/05/2013
09/06/2013
09/06/2013
09/08/2013
09/09/2013


How do I solve this?