The number column type is a general purpose field which can hold any numeric value like age of a person or a phone number. It can also be used to store computed values like sum or multiplication of other numbers.
It is not ideal to use this for numbers with more than 15 digits because such numbers get rounded. You can instead use text column type to store them.
There are three formatting options available. They are
- Normal: The number will be displayed as it is input by the user.
- Currency: The number will be displayed in currency format with a comma after every three digits.
- 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.