BoostExcel main content
Download
| Description | Size | Download |
|---|---|---|
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:
| 1460 KB | Download |
License: Private Use (not for distribution or resale). See our Terms of Use.
Screenshot
Detail
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
| Template# | c4060 |
| Belongs to | |
| Format (XLS or XLSX) | .xlsx |
| Columns | 4 |
| Lines | 12 |
| Line Height (Points) | 18.00 |
| Print Area | $D$2:$K$47 |
| Papaer Size / Orientation | Portrait |
| Default Margins (Points) | |
| Left | 22.68 |
| Right | 22.68 |
| Top | 45.35 |
| Bottom | 45.35 |
| Price | Free (0.00USD) |
Related
