Forum Discussion
Excel date formatting issue automatically changing date value to month
You must always enter dates according to your system date format, regardless of how the cell is formatted.
I assume that your system date format is dd-mm-yyyy. If you enter 01/08/2018, Excel interprets it as the 1st of August, 2018, and shows 01-08-2018 in the formula bar.
Formatted as m/dd/yyyy, this is displayed as 8/01/2018 in the cell.
If you want to enter the 8th of January, 2018, you must enter it as 08/01/2018 or 8-1-18 or similar because of the dd-mm-yyyy system date format. You'll see 08-01-2018 in the formula bar.
Formatted as m/dd/yyyy, you'll see 1/08/2018 in the cell.
You must always enter dates according to your system date format, regardless of how the cell is formatted.
I assume that your system date format is dd-mm-yyyy. If you enter 01/08/2018, Excel interprets it as the 1st of August, 2018, and shows 01-08-2018 in the formula bar.
Formatted as m/dd/yyyy, this is displayed as 8/01/2018 in the cell.
If you want to enter the 8th of January, 2018, you must enter it as 08/01/2018 or 8-1-18 or similar because of the dd-mm-yyyy system date format. You'll see 08-01-2018 in the formula bar.
Formatted as m/dd/yyyy, you'll see 1/08/2018 in the cell.
- Thank you Hans. This was the issue and I am able to successfully complete my work! Appreciate your help here 🙂
- Thanks to NikolinoDE and SergeiBaklan for the suggestions !
jishnuchandra1 , glad to help
