By default, the template displays US$ currency symbols. However, it is set up to easily apply any currency symbols as needed.

We can choose a sheet where we want to apply currency symbols. Let’s take Invoice sheet.

Press Ctrl+G to open the Go To dialog box.


 

Find the name ‘CURR’ and click OK.

Excel will now select all the cells for fields UNIT PRICE, UNIT DISCOUNT, TAX, AMOUNT AFTER TAX and the Order Total section fields.

This is assuming you have not modified the invoice fields. If you have changed or re-ordered the fields, then, please select the appropriate cells you need to apply currency symbols. 

 

Press Ctrl+1 to open the Format Cells dialog box.


Select ‘Currency’ in the Category and then choose the symbol from the drop down. Click OK. This will now apply the chosen currency to all the selected cells in the Invoice sheet. Please follow the same procedure in other sheets if you need to see currency symbols.

The calculations in the template are not impacted by currency symbols. This is purely for visual presentation.