2
2
In Excel when i enter a date into a blank cell (General format) as, say 7/15, the cell changes it's format to "Custom: m-ddd". How can i make doing this default to the standard default date "*3/14/12"? Note: my region "Short date" format is the standard U.S. "M/d/yy".
Have you checked your language settings in excel:
Option
>Language
>Editing language
,Display language
andHelp language
. Also try to enter the date in a brand new excel file/sheet and see what happens. Tell us the results of the above, and if the error persists – xypha – 2019-10-11T03:09:18.620Try to format date first. – Lee – 2019-10-11T08:39:05.227
Settings: Editing Language "English (United States) <default>" Display Language: "Match Microsoft Windows <default> Yes, it happens in a New worksheet.
(BTW i consider myself quite knowledgeable in Excel, have been using it for decades and written many VBA macros. I'm not bragging, just letting you all know where i'm coming from.) – Bill L – 2019-10-11T21:18:23.713
Yes, if the cell format is pre-set as "M/d/yy" then entering the date as 7/15 comes out correctly as 7/15/19. But i don't understand why typing 7/15 into a "general" cell won't come out this way also. Is this dd-mmm hard coded into Excel or is there a setting somewhere? – Bill L – 2019-10-11T21:29:05.100