How To Convert Date Formats to Other Locales
Suppose your worksheet shows dates in the US format, like mm-dd-yyyy. Now, if you want to change the formatting of the Date to the UK formatting rule, then here are the steps:
Step 1: Select the Data Range
First, you must select the date range on your Excel worksheet.
Step 2: Format Cells
After that, just hit the keys Ctrl + 1 to open the Format Cells dialogue box.
Step 3: Select a Format from the Type list
This is the third step, where you must select a date format shown in the Type list.
Step 4: Change Format and Click Ok
Now, click on the Locale drop-down menu below the Type list and select English (UK). Click OK button.
How to Change Date Format in Excel
You know that Excel is one of the best spreadsheets you can work on. Excel is the first preference of many users to create an impressive data set. Have you tried filling in the Date on the sheet? Date with the data is a common practice done by users in Excel to get information timeline.
To help organize data in an Excel worksheet, we will discuss four easy yet effective ways to change the date format in Excel.
Contact Us