List of Currency Symbols in Excel

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. List of Currency Symbols in Excel

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:

  1. Select a blank cell.
  2. Go to Insert tab > Symbols group > Symbol.Where to Access Symbols optionThe Symbol dialog box will appear.
  3. In the Symbol dialog box:
    • Click Symbols tab > Subset drop-down > Currency Symbols.
    • Select the desired currency symbol > Insert.
    • Click Close.
    Currency Symbols Group

Repeat the previous steps for other currency symbols to create a list of them. Inserting Currency SymbolsNote: 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

  1. Select a blank cell (B5 here) and insert any value.
  2. Drag the Fill Handle down the column holding the Ctrl key. Insert Values
  3. Select a cell with value > press Ctrl+1 keys.
    The Format Cells dialog box appears.
  4. In the Format Cells dialog box:
    • Go to Number tab > Currency Category > Symbol drop-down.
    • Select desired currency format.
    • Click OK.
    Currency Format

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.

Currency Formatted Cells

Step 2: Create Function using VBA

  1. Go to Developer tab > Code group > Visual Basic or press Alt+F11 keys. How to Open VBA WindowThe VBA window opens.
  2. Select Insert tab > Module. Open Module Window
  3. Insert the code below to create a custom function named GCS:
    Function GCS(ByVal Rng As Range) As String
    Static XReg As Object
    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
  4. Click the Save icon. Creating Function with VBAThe Save As window appears.
  5. Select Excel Macro-Enabled Workbook as type > Save. Saving Macro-Enabled file

Step 3: Create List of Currency Symbols

  1. Go back to the workbook and select a blank cell.
  2. Insert the formula: =GCS(B5)
  3. Drag the Fill Handle down the column. Thus, you will get the currency as follows. Inserting VBA function
  4. Select the currency range and press Ctrl+C keys to copy.
  5. Select a cell from a new column and paste as Values. Custom List of currency symbols

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.


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!
Md. Shamim Reza
Md. Shamim Reza

Md. Shamim Reza, a marine engineer with expertise in Excel and a fervent interest in VBA programming, sees programming as a time-saving tool for data manipulation, file handling, and internet interaction. His diverse skill set encompasses Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning. He holds a B.Sc in Naval Architecture & Marine Engineering from BUET and has transitioned into a content developer role, generating technical content focused on Excel and VBA. Beyond his professional pursuits,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF