Date formatting

[Billa_Mani]

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.2012"

here "04" is the first value and take it as  month value so it will be easily formatted but if the date format is more than the month value like "22.02.2019"  here "22" cant be converted beacause it is a month so i cant convert it into the format of "mm/dd/yyyy".

[#2]

@Billa_Mani 

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.