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:
This template demonstrates how to make the "Price" field show 4 digits after the decimal point.
In the database, the "Price" field appears in two places: the Product table and the InvBdy table. The "Price" field is defined as "decimal (15, 6)". This means it can store up to six digits after the decimal point.
- Backup your template.
- Open the template.
- Click the "Design Mode" button on the ribbon tab. This switches the spreadsheet to design mode.
- Drag your mouse to select all the "Unit Price" cells.
- Right-click one of the selected cells. Choose "Format Cells" from the shortcut menu.
- The "Format Cells" dialog box appears, with the "Number" tab activated by default.
- In the "Category" list, "Custom" is selected. The current format code is shown in a text box.
- Change the format code so that it looks like this:
_ * #,##0.0000_ ;_ * -#,##0.0000_ ;_ * ""??_ ;_ @_
This format code forces Excel to display four digits after the decimal point.
- Click OK to close the "Format Cells" dialog box.
- Exit design mode.
- Save the template.
Format and Specification
|Format (XLS or XLSX)||.xlsx|
|Line Height (Points)||18.00|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|