Forum Discussion
Sangwon_seo
Jan 16, 2020Copper Contributor
How do I use date format in Excel, automatically ??
Good day ! Please help me how to fix my Excel... By the way, As I know, Excel is already pre-programmed. (ex. If I add "20/01/16" or "20-01-16", It will be changed automatically to "20(yy). ...
Sangwon_seo
Jan 16, 2020Copper Contributor
Good day Sir !
Thanks for your reply.
I did it. But it doesn't work.
Do you know other options ??
As I guess, I need to change some system options...
Abiola1
Jan 16, 2020MVP
Hello, you need to Change your regional setting from your laptop or computer:
1. Type in Control Panel
2. Select Change clock, time and date format under Regional settings
3. Select additional settings
4. Locate the date tab and change appropriately
1. Type in Control Panel
2. Select Change clock, time and date format under Regional settings
3. Select additional settings
4. Locate the date tab and change appropriately