Monday, December 5, 2016

conversion - Convert "mmmm d, yyyy" format into "dd/mm/yyyy" format with Excel

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.



data




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

hard drive - Leaving bad sectors in unformatted partition?

Laptop was acting really weird, and copy and seek times were really slow, so I decided to scan the hard drive surface. I have a couple hundr...