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.
There are three formatting options available. They are as follows -
1. Normal: The number will be displayed as it is input by the user.
2. Currency: The number will be displayed in currency format with a comma after every three digits.
3. Accounting: The number will be displayed in accounting format, i.e : negative values will be represented in “(value)” format.
You can add a prefix or a suffix like a currency symbol to the number by using the prefix/suffix option.