Jul 01 2021 02:34 AM
Can some body help me with suggestions to change date format
I want the date as say 02-Mar-21
I select a cell and go to format menu in Excel and select the format 14-Mar-21
Now when I type 03-04-2021, It should display 03-Apr-21, But it keep on displaying the date as 04-Mar-21. Why excel is not accepting the changed
Jul 01 2021 02:42 AM
Here are some suggested solutions and formulas
Hope I could help
Nikolino
I know I don't know anything (Socrates)
Jul 02 2021 01:04 PM
It doesn't matter how do you format the cell, that only affects how to show the date. When you enter it Excel recognize it in accordance to locale date setting for Windows (or on which platform you are).