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.bhav...@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.bhav...@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 > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
