Short Date Format in Excel
When you type something like 2/2 into an Excel cell, Excel automatically assumes it’s a date. It then formats that date based on your computer’s regional settings. For example, Excel might display it as 2-Feb or 02/02. This means the way dates appear in Excel depends on: If you don’t like the default format, Excel