Excel - Date Conversion

Was this post useful to you?

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.

Hozy's picture
Hozy
Wed, 09/26/2012 - 09:57

2 Answers for "Excel - Date Conversion"

What is the format of your date column at the moment?

first copy than chose paste special command conversion data

Post your reply

Filtered HTML

  • Allowed HTML tags: <b> <br> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.