|
|
#1
12-19-2014, 08:29 AM
|
|||
|
|||
Date format but with Jan Feb mar etc how is this done ?
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 
|
| Tags |
| date format |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Letter date changes when merging with Excel - not the format, the actual date! | Smallweed | Mail Merge | 1 | 02-07-2014 06:00 PM |
| Date format in excel vba | LaercioNB | Excel | 3 | 08-09-2013 06:33 AM |
 Timeline date format
|
mikeg | Project | 1 | 04-19-2013 06:26 AM |
|
MS Query date format
|
remigio | Word | 3 | 08-21-2012 10:54 PM |
| date format | gsrikanth | Excel | 1 | 12-28-2011 05:06 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode