Note: The other languages of the website are Google-translated. Back to English
Log in  \/ 
x
or
x
Register  \/ 
x

or

Add currency symbols in Excel

In this tutorial, we will talk about how to add a currency symbol to the result of a formula or any numbers in Excel. Our ExtendOffice team has listed 3 ways below:

Add “currency symbol”& after the equal sign of an Excel formula

Add currency symbols to numeric cells with shortcut keys

Add currency symbols with Format Cells feature in Excel


Add “currency symbol”& after the equal sign of an Excel formula

add currency symbols 01

As we can see from the table above, there are no currency symbols before the values in the revenue column. Let's say we need to add the dollar sign ($) before the values, how can we get the work done quickly? For the formula =SUMPRODUCT(B2,C2), we can add "$"& after the equal sign (=) of the formula, and press ENTER. Now you can see the dollar sign appearring next to the first digit of the formula’s result.

add currency symbols 02

Then you can copy the formula to the cells below by dragging the fill handle down.

☞ Tips: To add other common currency symbols, here we have listed some ALT codes:

ALT codeCurrency symbolDescription
Alt + 36 $ Dollar
Alt + 155 ¢ Cent
Alt + 156 £ Pound
Alt + 157 ¥ Yuan
Alt + 0128 Euro
How to use: Press and hold down Alt, type the code value on the numeric pad, release Alt.

Add currency symbols to numeric cells with shortcut keys

This method will use Ctrl, Shift, and the dollar sign (4) on your keyboard. Easy to use and remember.

1. Select any cell(s) with a numeric value where you want to add a currency symbol.
2. Press and hold down Ctrl + Shift, then press the dollar sign (4).

The shortcut is to apply the Currency format with two decimals and thousands separator (,). This is how it looks after applying the trick on columns B and D:

add currency symbols 03


Add currency symbols with Format Cells feature in Excel

There are 2 ways to add currency symbols in cells with the Format Cells feature --- Currency formats and Accounting formats. First, let’s take a look at the differences between the two formats:

add currency symbols 04 With Currency Formats:
• The currency symbol spears next to the first digit of the numbers.
• Zeros and negative numbers are shown regularly.
• You can specify the format for negative numbers in four options: -$12.3, -$12.3, ($12.3), or ($12.3). (If you don’t like the existing options, create your own format in the category Custom of the Format Cells feature.)

 
With Accounting Formats:
• The currency symbol is on the left edge of cells.
• Zeros are written as a hyphen (-).
• Negative numbers are enclosed in parentheses without negative signs.


Now that you have a clearer idea that which format suits you better, let’s move to the usage of each feature.

Add currency symbols to numeric cells with Currency formats

add currency symbols 05

Let’s say you want to add currency symbols to columns B and D:

1. Select one of the columns, hold Ctrl and select the other one.

2. Choose a way you like to open the Format Cells window:
    a. Press Ctrl + 1.
    b. Right-click on any selected cell(s), click Format Cells on the context menu.
    c. Click the Dialog Box Launcher next to Number on the Home tab of Excel.
    add currency symbols 06

3. Go to Currency under the Number tab. Set the decimal places, currency symbol, and format for negative numbers.
add currency symbols 07

4. Click OK.
add currency symbols 08

Add currency symbols to numeric cells with Accounting formats

add currency symbols 09

Here is the same example to add currency symbols to columns B and D:

1. Select one of the columns, hold Ctrl and select the other one.

2. Choose a way you like to open the Format Cells window:
    a. Press Ctrl + 1.
    b. Right-click on any selected cell(s), click Format Cells on the context menu.
    c. Click the Dialog Box Launcher next to Number on the Home tab of Excel.
    add currency symbols 10

3. Go to Accounting under the Number tab. Set the decimal places and currency symbol.
add currency symbols 11

4. Click OK.
add currency symbols 12

√ Note: To remove the currency formatting of specific cells, you should select the cells first, then open the Format Cells window and go to General under the Number tab, click OK.



  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns and Keeping Data; Split Cells Content; Combine Duplicate Rows and Sum/Average... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Favorite and Quickly Insert Formulas, Ranges, Charts and Pictures; Encrypt Cells with password; Create Mailing List and send emails...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • Pivot Table Grouping by week number, day of week and more... Show Unlocked, Locked Cells by different colors; Highlight Cells That Have Formula/Name...
kte tab 201905
  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
officetab bottom
Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.