Number
The Number field is exclusive to accommodate only numbers. You can also input negative numbers.
How does it work?
- Select Number from the list of field types, by clicking the +icon from the field header.
- Choose the Precision value ranges from 1.0, 1.00, 1.000 or None.
- Enable/Disable, Thousand separator.
- Hit Enter
Note:
- The precision and thousand separator options are both disabled by default.
- The maximum number of digits allowed in a number field is 15. If this limit is exceeded, the value will be rounded to the nearest 15-digit number.
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Create. Review. Publish.
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Design. Discuss. Deliver.
Related Articles
Phone Number
The phone number field type identifies the numbers in the field as phone numbers and hyperlinks it. How does it work? Select phone number from the list of field types, by clicking the + icon from the field header. The field is now ready for phone ...Percentage
Percentage fields display numbers as percentages. You can also input negative numbers. How does it work? Select the Percentage field from the list of fields available. Choose the Precision value ranges from 1.0,1.00, 1.000 and None. Enable/Disable ...Autonumber
Autonumber fields automatically assign a unique, incremental number to each record, making identification easy. Note: The Autonumber field is not intended to count the number of records in a table. When a record is deleted in between, the rest of the ...Currency
The currency field type customizes a field with international currencies. The currency types supported are: US Dollar European Euro British Pound Japanese Yen Canadian Dollar Australian / New Zealand Dollar Chinese Yuan Fr. Swiss Franc Singapore ...Summary Measure
The summary measure bar provides the summary of all the cells in a particular field. The summary measure bar is present at the bottom of each field. By clicking the down arrow in the summary field, you can select the summarization options for the ...