UniformSoftware main content

Simple Sample: Using Currency Symbol

Template#: c4050

Download

DescriptionSizeDownload

The template works with both the Microsoft Store edition and the desktop edition of the app. Make sure you have installed one of them.

How to use:

  1. Download the EXE package.
  2. Double-click to extract the files into a folder. Make sure you have full access privileges to the folder, such as a subfolder inside “My Documents”.
  3. Open the template.
441 KBDownload

License: Private Use (not for distribution or resale). See our Terms of Use.

Screenshot

The screen shot for Simple Sample: Using Currency Symbol

Detail

This form details the steps required to show a currency symbol for certain fields, for example, "Unit Price", "Line Total", "Subtotal", "Total", "Paid", and "Total Due".

This template is based on the Simple Invoice Template: Moving Item# Column (c4049).

  1. Backup your template.
  2. Open the template.
  3. Click the Design Mode button on the ribbon tab.
  4. Click and select the cells that you want to set a currency symbol for. In this example, we set currency symbols for the following cells: all "Unit Price" cells, all "Line Total" cells, Subtotal, Total, Tax1, Tax2, Shipping Cost, Total, Paid, and Total Due. To select multiple cells, push the CTRL key on your keyboard and click each cell one by one.
  5. Release the CTRL key.
  6. Right-click one of the selected cells and choose Format Cells.
  7. On the Format Cells dialog box, choose the Number tab.
  8. Choose either the "Currency" or "Accounting" category. Both categories have pre-defined formats that show a currency symbol before a number. For more information about currency formatting, visit Format numbers as currency on the Microsoft 365 web site. In this example, the cells are formatted using the United Kingdom currency symbol ("£").
  9. Click the "Design Mode" button again to exit design mode.
  10. Save the template.

Format and Specification

Template#c4050
Belongs to

Sales

Format (XLS or XLSX).xlsx
Columns4
Lines12
Line Height (Points)18.00
Print Area$D$2:$K$46
Papaer OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35
PriceFree