Change Date Formats in Excel As per your Country Location | | Ali IT BD
Change date formats with the Format Cells feature
Select the Number tab.
Choose Date from the category list.
Specify which country's date formats you want to use from Locale (location) drop down list.
Select the date format from Type list. See Screenshot:
Follow these steps to do your formatting:
Select the cell (or cells) you want to format.
Choose Cells from the Format menu.
Make sure the Number tab is selected.
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.
Ali IT BD