When typing dates into unformatted (General format) cells, Excel will change the format to a custom date format, but I'd rather it just stick to either the short or long format.

Examples:

11/28 : 28-Nov (this isn't the common US format)
Nov 28 : 28-Nov ("")
November 28, 2018 : 28-Nov-18 ("")
11/28/18 : 11/28/2018 (system Short Date)
11/28/2018 : 11/28/2018
11/28 4:00 pm : 11/28/2018 16:00 (should be "4:00 pm")

The region format in the Region control panel is the standard short (M/d/yyyy) and long (dddd, MMMM d, yyyy) date and time (h:mm tt) formats for "English (United States)."

Is there a way to have Excel use the system/short format by default for dates or date-times when typed into a unformatted cell?

Thanks.

(There are several questions on changing the default format, but they are requesting displaying in something other than the system format, creating a custom format, or converting data to a new format.)

1 Answer

To get rid from the issue do the followings:

• In Control Panel find & Click Clock, Language and Region.

• Check this Screen Shot & set parameters as show.

  • Next, Click Keyboard & Language and find Change Keyboard Button.
  • From the General Tab ensure that English (United State)-US and Keyboard, English (United State) has been added.
  • Finish with Ok.

Note:

1. Then after, whenever you type date in General Formatted Cell will looks like, 11/29/2018.
2. Function =Now() will return 11/29/2018 12:40.
3. Function =Today() will show 11/29/18 and =TIME(12,40,0) will return 12:40 PM.

2

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy