krishco68
New Member
- Joined
- Nov 28, 2018
- Messages
- 21
- Office Version
- 365
- 2021
- 2019
- Platform
- Windows
Dear Excel Masters,
Since yesterday I am facing one problem in my excel. I have a date column in an excel table. It was formatted as DD-MMM-YYYY and worked properly.
previously I use to enter only date and month and press Enter button the desired format will reflect automatically, but since yester day eventhough I enter the date and month the given formated date is not coming automatically. The example given below
Column A (Formatted as DD-MMM-YYYY)
Previously when I enter date and month the press Enter the full formatted date use to appear automatically
Now when I enter the date and month and then press Enter, nothing is coming automatically only the date and month reflects in the cell. again I need to rearrange the format cell.
Please provide solution for the problem
Regards,
Murali Krishna
Since yesterday I am facing one problem in my excel. I have a date column in an excel table. It was formatted as DD-MMM-YYYY and worked properly.
previously I use to enter only date and month and press Enter button the desired format will reflect automatically, but since yester day eventhough I enter the date and month the given formated date is not coming automatically. The example given below
Column A (Formatted as DD-MMM-YYYY)
Previously when I enter date and month the press Enter the full formatted date use to appear automatically
Now when I enter the date and month and then press Enter, nothing is coming automatically only the date and month reflects in the cell. again I need to rearrange the format cell.
Please provide solution for the problem
Regards,
Murali Krishna