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 |