lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
My computer date/clock is DD-MM-YYYY. So I tried to enter the following. I understand all except 3rd and the 5th (the last) rows. Why Excel accepted
yyyy-m-dd as a date and why accepted sept 14, 2019 as a date and changed to 14-sept-2019. but why did not change it to 14-09-2019 (why 09 changed to sept). Thank you very much
<colgroup><col><col></colgroup><tbody>
</tbody>
My computer date/clock is DD-MM-YYYY. So I tried to enter the following. I understand all except 3rd and the 5th (the last) rows. Why Excel accepted
yyyy-m-dd as a date and why accepted sept 14, 2019 as a date and changed to 14-sept-2019. but why did not change it to 14-09-2019 (why 09 changed to sept). Thank you very much
I typed | press enter |
14-09-2019 | 14/09/2019 |
9-14-2019 | 9-14-2019 |
2019-9-14 | 14/09/2019 |
2019-14-9 | 2019-14-9 |
sept 14, 2019 | 14-Sep-19 |
<colgroup><col><col></colgroup><tbody>
</tbody>