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). ...
PascalKTeam
Jan 16, 2020Iron Contributor
Hi Sangwon_seo
Most likely a regional or language setting. In which language is your excel and where are you located?
Take a look at attached file. Does it show all days of January 2020?