I HAVE DATA SHEET THAT GIVES THE DATE AS FOLLOWS: 6/23/2010.
MONTH/DATE/YEAR
I WANT TO CHANGE THE DATE TO 23/6/2010 [DATE/MONTH/YEAR]TO ENTER INTO MY SPREADSHEET.
HOW DO I DO THIS.
THANKS
JOE