lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
My computer time is formatted as dd/mm/yyyy
if I enter a date like 19/04/2021 excel will move it to the right hand side. which is good
if I enter a date like 04/19/2021 excel will keep that to the left hand side (not date) which is good too and correct
When I enter 2021/04/19 excel will change the order and make it 19/04/2021 and move it to the right. Why is that? I thought it should not accept it as a date since my computer format dd/mm/yyyy
There is no day 2021?
Thank you very much.
My computer time is formatted as dd/mm/yyyy
if I enter a date like 19/04/2021 excel will move it to the right hand side. which is good
if I enter a date like 04/19/2021 excel will keep that to the left hand side (not date) which is good too and correct
When I enter 2021/04/19 excel will change the order and make it 19/04/2021 and move it to the right. Why is that? I thought it should not accept it as a date since my computer format dd/mm/yyyy
There is no day 2021?
Thank you very much.