Date formats

vijay - Dec 4, 2014 at 10:59 PM

i have problem in the date formats
i have an excel sheet with data
i am trying to filter by date
this is the date format - dd/mm/yyyy
but some data takes 01 as day and for some data it takes as month
so when filtering by the date wise.. i am not getting correct data
how to set this problem
how to make all the cells as one format
while changing the date format.. its not working