Number Rounding and Scaling Overview

Wdesk allows you to determine the precision of numbers in your documents using the Entered In and Shown In functions in spreadsheets and tables.

Entered In Values

The Entered In option allows you to determine the scale of values you input. For example, entering 5 in a cell with Entered In set to thousands will give the cell a value of 5,000. Similarly, entering 5 in a cell with Entered In set to millions will give the cell a value of 5,000,000. You can choose to enter information as cents (hundredths), ones, thousands, millions, billions, and trillions. Your selection will be visible in the drop-down menu next to the formula bar.

  • The Entered In value will display in the Format Cells... menu but cannot be edited there. It must be edited in the drop-down next to the formula bar.

  • Certain cells are unable to have their Entered In value changed. These are:

    • Cells that are formatted as Date/Time or Text

    • Cells that are formatted as Percent (percent values are always shown in ones)

    • Cells that are destination links. Destination links will always follow their source cells Entered In value and will update appropriately when their source's value is changed.

  • You may select a range of cells and perform a mass update to the Entered In values. However, if some of the selected cells cannot be changed (due to above limitations), they will not be updated.

    image alt text

Entered In drop-down selection

Shown In Values

Your Shown In determines what scale your values will be displayed in. If you entered the number 5,000,000 in a table cell and an Entered In value of ones, selecting a Shown In value of thousands will display as 5,000 in the document (5,000 thousands = 5,000,000). This is purely a display option; a cell will still calculate using the Entered In scale. If you wish to display the exact number you entered in the formula bar you can set the Entered In and Shown In to the same value.

Certain cells are unable to have their Shown In value changed, these are: cells that are formatted as Date/Time or Text and cells that are formatted as Percent. Percents are always shown in ones.

The set number precision will also affect the cell value due to rounding and the number of displayed decimal places.

image alt text

Shown In drop-down selection