Chat with us, powered by LiveChat

Excel International Formats

How to Use International Currency and Formats in Excel

If your spreadsheet will have international use, it’s best to format it for the appropriate region so the data will be clear to your target audience.

Change the Windows Regional Format Settings

When Excel formats dates, times, and numeric values, it looks to the Windows regional format settings. When you change these settings in Windows, it will automatically carry over into Excel.

  1. Open the Control Panel.
    Change the Windows Regional Format Settings
  2. Click Change date, time, or number formats.
    Change the Windows Regional Format Settings

    The Region dialog box displays. Any changes made here will automatically be reflected in Excel and other applications on your computer.

  3. Select the regional format you want to apply.

    Notice you can preview examples of the formats based on the settings you picked at the bottom of the window.

  4. Click the OK.
    Change the Windows Regional Format Settings

Dates, times, and numeric values will automatically reflect these changes in Excel the next time you open the program.

Apply an International Currency Format

While the Windows regional setting automatically adjusts the format of dates, times, and numeric values, you must manually apply the currency format.

  1. Select the range you want to format.
  2. Click the Number Format list arrow in the Number group of the Home tab.

    In the menu, you’ll see any number formatting containing a currency symbol matches your selection in the Windows regional settings.

  3. Select Currency or Accounting.
    Apply an International Currency Format

Display a Date or Time in a Different International Format

You can change the date and time formatting of a specific cell or range to something other than the Windows settings.

  1. Select the range you want to format.
  2. Click the Number group’s dialog box launcher.
    Display a Date or Time in a Different International Format
  3. The Format Cells dialog box opens.

  4. Select Date or Time in the Category list on the Number tab.
  5. Select the international format you want to apply from the Locale (location) list.
  6. Click OK.
    Display a Date or Time in a Different International Format

The international format is applied to only the selected cell or cell range.