HomeApplicationOffice informationHow to format currencies in Excel

How to format currencies in Excel

If you want to represent numbers as currency, you must format the numbers as currency. To do this, you use Excel's Format Cellss tool.

Currency format

Step 1: Select (black out) the data area to format the number of currencies (1) => Press Ctrl + 1 (2) to open the Format Cells window .

How to format currencies in Excel Picture 1

Step 2: On the Format Cells window , select the Currency (1) line and select the options (2) :

  1. Sample: is the test sample that you install.
  2. Decimal places: number of characters that show the decimal part.
  3. Symbol: currency symbol shown. Excel default currency symbol is $ (Dollar). You have the option of other Excel currency symbols. $ Example (US)
  4. Negative numbers: how to denote negative numbers: put red color or put in brackets or use negative sign (-) in front.

After making your selection, press the OK button (3) .

How to format currencies in Excel Picture 2

=> Results obtained:

How to format currencies in Excel Picture 3

Tip: To quickly apply a currency format with the $ currency symbol, select the cell you want to adjust the format and press Ctrl + Shift + $ .

Accounting format

Besides currency format, accounting format ( Accounting ) also supports users to insert currency symbols.

Step 1: Select (black out) the data area to format the number of currencies (1) => Press Ctrl + 1 (2) to open the Format Cells window .

How to format currencies in Excel Picture 4

Step 2: On the Format Cells window , select Accounting (1) and select the options (2) :

  1. Sample: is the test sample that you install.
  2. Decimal places: number of characters that show the decimal part.
  3. Symbol: currency symbol shown. Excel default currency symbol is $ (Dollar).

To select other symbols, click the arrow and select the currency symbol you need.

After making your selection, press the OK button (3) .

How to format currencies in Excel Picture 5

=> The result you get is:

How to format currencies in Excel Picture 6

Tip: To quickly apply accounting format, select the cell you want to adjust the format and then click the currency icon on the Home tab of the Ribbon.

How to format currencies in Excel Picture 7

Remove currency format (Currency) or accounting (Accounting)

To remove the currency format, select the General format on the Format Cells window . Selected cells returning to the General format will not display any specific number format.

Above Software Tips showed you how to format currencies in Excel. Good luck!

4.5 ★ | 2 Vote

You should read it

May be interested

  • How to automatically wrap lines in Excel (Wrap Text in Excel)Photo of How to automatically wrap lines in Excel (Wrap Text in Excel)
    the line break in excel is not as simple as pressing enter as in ms word software. today, dexterity software will guide you to the warp text tool to automatically wrap lines that match the width of the column!
  • Absolute and relative addresses in ExcelPhoto of Absolute and relative addresses in Excel
    absolute and relative addresses in excel. relative addresses are addresses that change when copying a formula. this is the default address when we formulate the formula. for example a1, b2 ... the absolute address is the one that was not changed when copying the formula. the absolute address is distinguished from the absolute address with the character $. for example $ a1 $ 1, $ b1 $ 2….
  • Quickly insert multiple images at once in ExcelPhoto of Quickly insert multiple images at once in Excel
    today dexterity software will guide you how to quickly insert rows of images at once in excel with the tool ablebit for excel.
  • Excel date function - Usage and examplesPhoto of Excel date function - Usage and examples
    the date counting function in excel is one of the most effective functions of this software. because excel usually works in the field of statistics and calculations, it is extremely necessary to record dates. to help you understand this function, let's come to the following article of tipsmake.
  • How to lock Excel files from editingPhoto of How to lock Excel files from editing
    you want to send an excel file that can only be read by the recipient and cannot change the data information in the file. in this article, tipsmake.com would like to show you how to lock excel files from editing correctly.
  • How to separate text strings by commas or spaces in ExcelPhoto of How to separate text strings by commas or spaces in Excel
    separating text strings based on commas or spaces is a trick that helps you split the characters in a parameter cell into different clusters based on commas or spaces that parameter cell contains. tipsmake will guide you how to separate text strings by commas or spaces in excel.

Office information