how to set european date format in excel?
['Select the cell (or cells) you want to format.', 'Display the Home tab of the ribbon.', 'Click the small icon at the bottom-right corner of the Number group. ... ', 'Click Date at the left side of the dialog box. ... ', 'Using the Locale drop-down list, choose a country or region that uses the date format you want to use.']