How to format formula output in Zoho Writer
Overview
Zoho Writer allows you to format your formula's output using built-in formatting options.
Steps
In the New Formula window, which you can launch by going to the Fields tab --> Formula, you can customize the result using the available number formats, as shown below:
List of formatting options supported
|
S.No
|
Number Format
|
Description
|
Unformatted
|
Formatted as
|
|
1
|
0
|
Decimals are rendered as whole numbers.
|
1234.58
|
1234
|
|
2
|
0%
|
Numbers are converted to percentages.
|
12.58
|
12%
|
|
3
|
0.00
|
Numbers are accurated to two decimal places, without a thousand separator.
|
1234.5298
|
1234.53
|
|
4
|
0.00%
|
Numbers will be rendered as percentages with decimals.
|
22.2468
|
22.25%
|
|
5
|
#,##0
|
Values with decimals are rounded to whole numbers with a thousand separator.
|
1234.52
|
1,234
|
|
6
|
#,##0.00
|
Values with more than two decimals are accurated to two decimal places, with a thousand separator.
|
1234.5298
|
1,234.53
|
|
7
|
$#,##0.00;($#,##0.00)
|
Numbers are rendered as dollars, with brackets around negative numbers.
|
Positive = 12345.6942Negative = -12345.6942
|
$12,345.70 ($12345.70)
|
|
8
|
$#,##0.00;($#,##0.00)[custom-currency]
|
Custom currency will appear if the formula is entered in a different document locale than the current document locale.
|
Positive = 12345.6942
Negative = -12345.6942
|
INR 12,345.70 (INR 12345.70)
|
9 | Number To Text | Numbers are rendered as a cardinal number. | 10 | Ten |
10 | Number as Ordinal | Numbers are rendered as a ordinal number | 10 | 10th |
11 | Number as Ordinal Text | Numbers are rendered as a ordinal text | 10 | Tenth |
12 | Ordinal Year | Ordinal year is rendered as a cardinal number | 2025 | Two thousand twenty five |
Related Articles
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:
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
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.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
How to refer formula output across a document
Overview Zoho Writer lets you reference the formula's result across your document and perform calculations based on the formula's result. You can insert the formulas in paragraphs, tables, and merge and fillable templates. Steps Place the cursor in ...Getting started with document merge in Zoho Writer
Overview Zoho Writer’s template-based document generation lets you automatically create personalized documents by merging pre-designed templates with data from spreadsheets, forms, CRMs, or APIs. Merge fields pull in real data to generate contracts, ...How to use formula fields in Zoho Writer
Overview Zoho Writer allows you to insert formulas in documents to perform calculations on the fly. You can add formulas in paragraphs, tables, and merge and fillable templates. These formulas can be manually updated by the user. Additionally, you ...How to use circular formula reference in Zoho Writer
Overview Zoho Writer allows you to handle circular references in formulas by setting limits on iterations or defining a threshold for convergence. You can add formulas in paragraphs, tables, and merge and fillable templates in Zoho Writer. Steps ...How to use DATEDIF formula in Zoho Writer
Overview The DATEDIF function in Zoho Writer allows you to calculate the difference in days, months, or years between two dates. You can insert the DATEDIF function in paragraphs, tables, and merge and fillable templates in Zoho Writer. Syntax ...
New to Zoho LandingPage?
Zoho LandingPage Resources