December 4, 2020

How to apply currency format in excel

Let’s say we have the below table containing monthly expenses of a family for 6 months.

  • Here we need to apply the desired currency for the Amount column.
  • First select the cells B2 to B7.
  • Now in Home menu press $ under Number group to apply Dollar currency. Alternatively you can press the keyboard shortcut Ctrl+Shift+$.

  • See the $ currency applied for B2:B7

  • If you want any other currency symbol then press the down arrow beside the $ under Number group to open the list of available currency symbols and apply the required one.

  • This time we have applied Euro currency format as follows.

Leave a Reply

Your email address will not be published. Required fields are marked *