Date format excel settings

Click the small icon in the lower-right corner of the Number group. Excel displays the Number tab of the Format Cells dialog box. Click Date on the left side of the dialog box. (See Figure 1.) Figure 1. The Number tab of the Format Cells dialog box. In the Locale drop-down list, choose a country or region that uses the date format you want to use. ................
................