The default format is the set Date Format in Excel. We can view it as follows: select the “Home” tab > go to the “Cells” group > click on the “Format” drop-down > select the “Format Cells” option. The “Format Cells” window pops up, click the “Numbers” bar > go to the “Category” group on the left, and click on the “Date” option. In the “Type:” group, we will see the default date format with the “*” Asterisk sign, as shown in the following image. The set default Date is, 14-03-2012 March 14 2012