#1
|
|||
|
|||
Default date format
If I enter a date in a cell as 3/1, Excel displays 1-Mar. Who the heck ever writes dates like that? I don't anyway.
At any rate, is there a way to change it to some other format e.g. Short Date? This has bugged me years and I've never found an acceptable answer. Who the heck at Microsoft came up with the bright idea to have the default like this? "Great idea on that default date format, Stanley! How about something for time?" "I'm thinking Klingon standard." |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Default date, time format when importing CSV files | hwg | Excel | 3 | 11-17-2014 08:47 AM |
Letter date changes when merging with Excel - not the format, the actual date! | Smallweed | Mail Merge | 1 | 02-07-2014 06:00 PM |
Default dates for a Date Picker | BoringDavid | Word VBA | 2 | 09-11-2013 01:42 AM |
How to set Message Format default | TonyBender | Outlook | 0 | 10-27-2009 11:52 AM |
Default Number Format | boutells | Excel | 1 | 05-20-2009 02:46 PM |