Dear Sandeep, Do the following steps in Excel, If you open the excel sheet with open office, then: 1. Select whole column to which you want to apply the required date format. 2. Right click on any cell, and select Format cell, under Number tag option, Select Date format, in right pane select the desired format i.e. 1999-11-30, the Format Code is YYYY-MM-DD for that as you see under the same window, when you select that. 3. Apply or Click OK the whole column now set to ur required format. If you are using MS Office 2007 or 2010 then the steps are like below: 1. Select whole column to which you want to apply the required date format. 2. Right click on any cell, and select Format cell, under Number tag option, where Date format given, the last option is custom format. 3. Select Custom Format and in right pane under Type Text box, type your desired format i.e. YYYY-MM-DD, and select that from below as you add that format. 4. Apply or Click OK the whole column now set to ur required format. Hope your problem will solved now. BR// Sunil -------------------------------------------------------------------------------------------------- On Sat, Jun 9, 2012 at 5:30 PM, SANDEEP BHAVSAR <sandeep.bhavsar@gmail.com>wrote:
Dear All
Kindly help me in converting date format from DD-MM-YYYY to YYYY-MM-DD in Excel If possible give the solution step by step. I tried with "Text to Colums" options in Excel.
-- Thanks and Regards
Sandeep Bhavsar Librarian Dr.V.N.Bedekar Institute of Management Studies Thane(W) 400601 MUMBAI. INDIA @@@@@@@@@@@@@@@@@@@@@@@@@@ email : sandeep.bhavsar@gmail.com Mob : 9029 345777 elibrary :http://www.vpmthane.org/im/elib/main.htm @@@@@@@@@@@@@@@@@@@@@@@@@@ _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha