How to format formula output in Zoho Writer
Overview
Zoho Writer allows you to format your formula's output using built-in formatting options. You can customize the result using number format switches available as shown
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:
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 track merge status and handle errors in Zoho Writer
Overview You can track the status of the merge jobs using email notifications and the merge logs. While email notifications help you track the merge initiation and completion status, the merge logs help you track the status of jobs in progress, along ...How to customize lists in Zoho Writer
Overview Lists are a great way to organize content in your documents. In Zoho Writer, you can do more than just create simple bulleted or numbered lists. You can fully customize them. From setting your preferred list style as default to using images ...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 ...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 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. Steps How to add ...
New to Zoho LandingPage?
Zoho LandingPage Resources