UniformSoftware main content

Simple Sample: Decimal Precision of Product Prices

Template#: c4060

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.
984 KBDownload

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

Screenshot

The screen shot for Simple Sample: Decimal Precision of Product Prices

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.

  1. Backup your template.
  2. Open the template.
  3. Click the "Design Mode" button on the ribbon tab. This switches the spreadsheet to design mode.
  4. Drag your mouse to select all the "Unit Price" cells.
  5. Right-click one of the selected cells. Choose "Format Cells" from the shortcut menu.
  6. The "Format Cells" dialog box appears, with the "Number" tab activated by default.
  7. In the "Category" list, "Custom" is selected. The current format code is shown in a text box.
  8. 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.

  9. Click OK to close the "Format Cells" dialog box.
  10. Exit design mode.
  11. Save the template.

Format and Specification

Template#c4060
Belongs to

Sales

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