Hi,
Office 2010 Excel.

date format is now just numbers, or the full length month name,
But I want
14 Mar 2014
21 Jan 2014
18 Dec 2014 etc

as opposed to 18 December 2014 and likewise for the others.

How is this done ?

Full length makes the columns far too wide, I am surprised not to see the truncated version, I recall such in office 2000 if memory serves me correctly.
I also want to type a few out then select and drag right to auto fill the rest of my columns as is possible with existing formats, so any tweaking must allow this please.

DBenz