Dear Experts.
I request you all please let me know how can we give the space for the below continuion numbers in excel sheet by using formula. As data is large it will take longer time to bifurcate manually. Hence kindly help me out.
01/04/2012TO31/03/2013
I wanted the above in below manner.
01/04/2012 TO 31/03/2013.
and also let me know how can we change the date formate by defualt as DD/MM/YYYY for specified column by using short cut.
I come come across one short cut which is Cont+Shift+3 , by applying the same changes the entire selcted colomn as date formate as dd-mmm-yy. Here if i wanted the format as DD/MM/YYYY, how can I do that by using short cut ? is there any short cut key for the same ? If we can kindly help me out.
your kind reply would be appreciated.
Thanks in advance
Bookmarks