In my excel file, the format is something like "Sun Nov 01 09:54:40 IST 2015".

I want this like 01-Nov-2015 only.

I tried but it does not changing. Ctrl+1, select date and then choose format. But it did not work.