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.
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.
The Region dialog box displays. Any changes made here will automatically be reflected in Excel and other applications on your computer.
Notice you can preview examples of the formats based on the settings you picked at the bottom of the window.
Dates, times, and numeric values will automatically reflect these changes in Excel the next time you open the program.
While the Windows regional setting automatically adjusts the format of dates, times, and numeric values, you must manually apply the currency format.
In the menu, you’ll see any number formatting containing a currency symbol matches your selection in the Windows regional settings.
You can change the date and time formatting of a specific cell or range to something other than the Windows settings.
The Format Cells dialog box opens.
The international format is applied to only the selected cell or cell range.
Free to distribute with our compliments; we hope you will consider our paid training.