I am trying to change all of the dates in an excel spreadsheet to the mm/dd/yyyy format, but when I go to format the cells, it does not change, even when I have tried a custom format. In the format cells window, it says that it is currently set at *3/14/2001, but it is appearing as Apr 1 2013, Apr 3 2013 ...etc. Is there any way to format all of the cells the way that I want them? I have 1000+ dates, so I really do not have the time to go in and manually change all of them.
I did an example with a formula implemented to help you: http://speedy.sh/9Q5Cf/18-09-2015-EN-Kioskea-Date-Convert-TEXT-to-REAL-DATE-OK.xlsx
Now that the date are real date you can change a format using a cell menu format. Try it.