How to change the format of date, time, number, and currency in Windows 11

The time and date of each region have differences. As a result, computers and smartphones have a date and time set to your current location by default.

Despite having standards, date and time formats differ from place to place. And you may not be familiar with the default format of Windows.

Windows 11 by default displays the date in the Taskbar formatted with a forward slash, two numbers for the year (12/19/20 22), and a 12-hour format for the time (9:29 AM), but you can easily change this setting according to the format you want.

There are several ways to display numerical data in Word documents and Excel spreadsheets. A number shows the number of many types, such as sales volume, number of goods, length, weight, exam results. Date and time can also be used as values. System settings are used to represent numeric data in Microsoft Word, Excel, and PowerPoint.

Here are some ways that you can use to change the settings of dates, numbers, and currency formats in Windows 11.

Change Regional Settings Windows 11 to change the appearance of certain data types

When you apply the formatting options, your date/time, numeric, and currency data types will appear differently depending on your Microsoft Windows Regional Settings.

Windows supports many languages, as well as currency and date/time formats used in countries and regions where those languages are spoken.

Follow these instructions to change the Regional Settings for Windows.

Change Local Format: date, time, numbers, and currency

1. Open the “Control Panel” Windows 11. You can open it by using the keyboard shortcut (WIN + R), then type “control” and click the OK button.
2. In Control Panel, click “Region“.

3. In the dialog box that appears, select the “Formats” tab.

4. Then, click the “Format” dropdown button and select a format according to the local format of the country you are using. This option will change the default of the date, time, number, and currency formats that the system uses.
5. Click the OK button to save the changes.

Change the date and time format

To change the date and time display without changing the Windows local format, you can do this by:

1. In the “Region” dialog box, select the “Formats” tab.
2. In the “Date and time formats” field, click the dropdown button and select the options.
3. Click the “Short date” dropdown button and select the options to change the short date display.

4. Repeat to select the format display “Long date, Short time, Long time, First day of week.
5. Click the OK button to save the changes.

Change the number format

1. In the “Region” dialog box, click the “Additional settings” button.
2. Next will appear a new dialog box “Customize Format“, select the “Numbers” tab.
3. In this tab, you can change the settings of decimal symbols, thousands separators, negative signs, and others.

4. Click the OK button to save the changes.

Change currency format

1. In the “Region” dialog box, click the “Additional settings” button.
2. Next, in the new “Customize Format” dialog box, select the “Currency” tab.
3. In this tab, you can change the settings of currency symbols, thousands separators, and others.

4. Click the OK button to save the changes.