Decimal Column

A Decimal column type is used to store a decimal value.

When you click on the down arrow next to the Column Name you will see the list of options shown below. You can set the precision of the decimal value and it will show the number of digits after the decimal points accordingly.

Formatting options

There are three formatting options available. They are as follows -

image

1. Normal : The number will be displayed as it is input by the user.

image

2. Currency: The number will be displayed in currency format with a comma after every three digits.

image

3. Accounting: The number will be displayed in accounting format, i.e: negative values will be represented in “(value)” format.

image

You can add a prefix or a suffix like a currency symbol to the number by using the prefix/suffix option.

The sort option can be used to sort the rows from first to last or last to first based on the value of this column. Read more about sort here.

You can use conditional formatting to better visualize the entries in each cell. For more details on conditional formatting options, you can refer to this.