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.