Excel allows you to insert various currency symbols as required. With the help of this set of currency symbols, users may accurately represent and analyze financial data with precision. Whether you are creating financial reports, handling international transactions, or just enhancing the presentation of your data, knowing and using these symbols can greatly improve the professionalism and clarity of your Excel sheets.
You can easily insert some currency symbols using keyboard shortcuts, while others can be inserted as symbols. However, you may not be able to insert all the currency symbols as just symbols in Excel. You can extract currency symbols and create a custom list using VBA. In this Excel tutorial, you will learn how to access and create a list of currency symbols in Excel.
The following overview image illustrates a list of currency symbols with its corresponding currency code, currency name, country, and some keyboard shortcuts for Windows and Mac.
How to Access and Insert List of Currency Symbols in Excel
In this section, you will learn where to access and how to insert currency symbols in Excel. Here’s how:
- Select a blank cell.
- Go to Insert tab > Symbols group > Symbol.The Symbol dialog box will appear.
- In the Symbol dialog box:
- Click Symbols tab > Subset drop-down > Currency Symbols.
- Select the desired currency symbol > Insert.
- Click Close.
Repeat the previous steps for other currency symbols to create a list of them. Note: Keyboard shortcuts only work by using the Numeric Keypad, so ensure that your Num Lock key is turned on. Here is a list of currency symbols in Excel with some keyboard shortcuts for both Windows and Mac.
How to Create a Custom List of Currency Symbols in Excel
You may not be able to insert all the currency symbols available only from Symbols group in the Insert tab. However, you can Format Cells and use VBA to extract other currency symbols and create a customized list. Here’s how:
Step 1: Format Cells to Currency Format
- Select a blank cell (B5 here) and insert any value.
- Drag the Fill Handle down the column holding the Ctrl key.
- Select a cell with value > press Ctrl+1 keys.
The Format Cells dialog box appears. - In the Format Cells dialog box:
- Go to Number tab > Currency Category > Symbol drop-down.
- Select desired currency format.
- Click OK.
Thus, the cell will be formatted according to your selected currency format. Repeat the previous steps to apply a different currency format for each value in the column to get the following result.
Step 2: Create Function using VBA
- Go to Developer tab > Code group > Visual Basic or press Alt+F11 keys. The VBA window opens.
- Select Insert tab > Module.
- Insert the code below to create a custom function named GCS:
Function GCS(ByVal Rng As Range) As String Static XReg As Object Application.Volatile If XReg Is Nothing Then Set XReg = CreateObject("VBScript.RegExp") End If With XReg .Global = True .Pattern = "[0-9-.,\s]" GCS = .Replace(Rng.Text, "") End With End Function
- Click the Save icon. The Save As window appears.
- Select Excel Macro-Enabled Workbook as type > Save.
Step 3: Create List of Currency Symbols
- Go back to the workbook and select a blank cell.
- Insert the formula:
=GCS(B5)
- Drag the Fill Handle down the column. Thus, you will get the currency as follows.
- Select the currency range and press Ctrl+C keys to copy.
- Select a cell from a new column and paste as Values.
Finally, you have created a custom list of currency symbols in Excel.
Download Practice Workbook
You can download the practice workbook from the button below.
Conclusion
If you work with financial data or create spreadsheets for audiences throughout the world, learning how to handle currency symbols in Excel is essential. Through this tutorial, you have learned how to access and insert a list of currency symbols using the Symbols group and create a list of currency symbols combining VBA with Format Cells. If you have any further queries, please comment down below.
Frequently Asked Questions
Can I customize the currency symbols in Excel?
Excel comes with a default set of currency symbols, but you may change the formatting even further. Use Custom option from the Format Cells dialog box to build a custom format with specified currency symbols or formatting rules.
Can I convert currency values in Excel?
Yes, Excel has functions for currency conversion. The currency values in your Excel sheet may be automatically updated and converted using the CONVERT function or other data sources.
Can I use currency symbols in Excel formulas?
Yes, you can use currency symbols in Excel formulas. As long as the cells used in the calculation are formatted as currency, Excel will handle the symbols appropriately.
<< Go Back to Currency Format | Number Format | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!