Forum Discussion
Date formatting
Hai, Im having the date format of "22.02.2012"in excel I need to convert into "02/22/2012". But the what the issue is if im having the lesser month values in front of the date value like "04.05.20...
I assume you want to display dates as "mm/dd/yyyy".
First make sure all you data are really date values. I.e. not text looking like a date. You mention a date "22.02.2012". Obviously, this is 22 February. Then you mention "04.05.2012". This is 4 May, right? When you say that the "04" is taken as the month. That's wrong, isn't it?
Make sure your "dates" are consistent. All should be like "dd.mm.yyyy". Then you could use "Text to columns" (in the DATA menu and ribbon) to convert the "text-dates" to real dates. Just make sure that you indicate that the date is "DMY". After that, you can reformat the date to what you need.