Just right click on the cell and click format cell, then go to date and select the desired format you wish to use. There is also custom tab there to use your specific format.
Do watch Gadgetwala review of Mi5. It specifies lots of software based issues in the phone on random basis. Me too looking for same but put plans on hold until OnePlus 3 is out.
Here is my suggestion based on your requirement in preferential order -
OnePlus One (22k)> LG G2 (27k) > HTC One E8 (30k) > LG G3/HTC OneM8/ Xperia Z2 (36k)
Stay away from Lenovo. Great Specs but very bad performance + low resale value.
Don't ignore LG's for its brand value, G2 and G3 are...
HTC 816 is good and Nexus 5 is excellent and far better. The only -ve in Nexus 5 is truly average battery life. It's far better to go for LG G2 at 27k. It's re-skinned Nexus with awesome battery life. Currently your best bet will be to get your hands on OnePlus One available through Amazon.in...
Within the budget of 15k and considering good performance and reliability, I would suggest you to go for Moto G (1st Gen). You may also opt for Lenovo P780 but it's little older and will not support latest Android OS. Don't go for newer Lenovo models boasting of large batteries, there...
Had a fabulous deal today at ebay. Bought 8 month old used HTC ONE at 23k after applying 8% IPL special coupon code. Coupon - CRICEBAY26 Min. purchase 8000, max. discount 2000 validity - 24/04/2014. Not Applicable on Deals & Discounted items. Applicable on Mobiles | Laptops | Cameras...