I have copied a file from another computer to Excel in CSV format. the source
computer has the date in the format 07/11/13 (it's actually 2007/11/13) and
it is displaying in Excel as 7/11/2013. If I go into Excel and change the
format of the cell to yyyy/mm/dd format it changes it to 2013/07/11 which is
still wrong.

How do I get 7/11/13 to display as 2007/11/13