Hi Sir, i have one date column and date format is 01.06.2015 10:45 how to convert the date in dd-mmm Format Thanks for your help in advance..
=text(substitute(a1,".","/"),"dd-mm-yyyy")
Latest answers from Nagaraju Bezawada
Hi Sir, I have one date column and date format is 01.06.2015 10:45 ..Please suggest me how to convert the date into dd-mmm Format. Thanks for your help in advance.. Kumar
=TEXT(SUBSTITUTE(A1,".","/"),"dd-mm-yyyy")
How to find sub total and grand total in pivot table?
Right click and choose formalas or click on the header and choose group
how to create combination chart in excel 2013...?
By using combo charts in insert ribbon tools
hellooooooooooooooo
excel is nice
what is the full fom of vba?
visual basic for applications