I have a bunch of data with strings of the format "mmmm d, yyyy", (for example: December 7, 2015 , or January 10, 2016). I want to convert these strings to dates with the format: dd/mm/yyyy (for example: 20/04/2012). However, I have not been able to find a way how to do this.
Your help is much appreciated.

Edit: I figured it out
My computer date time settings (windows 7) were European, whilst the date format "mmmm d, yyyy" is American. Basically what I did was change the operating system long date to be "mmmm d, yyyy" after which excel recognized the dates.
Here's a link if you do not know how to change the settings: http://www.pcadvisor.co.uk/how-to/software/how-to-change-the-date-and-time-on-your-pc-3267622/ look at step three.
No comments:
Post a Comment