Excel - Date Conversion
I have converted a PDF file to xls & in it i have a date column & i need to change the format (01/01/2012) because when i am trying to filter the dates it is not giving a proper filteration like monthwise then daywise. It is just arranging the dates in ascending order considering the day in the date eg. 01/03/2012 followed by 04/02/2012.
Please help me as how can i change this date format. Also pls be informed that i know the procedure of date changing from the format cells>number>date but that's not working.