It is also possible to put format for the result of calculation.
For example,
2500 -20*52.88 = 1442.40 (without thousand separator (comma))
We can set the format by the following steps
- Shift-F9 to edit the field
- After the formula, add the formatting code as \# ,0.00
- The field will look like this { =2500-20*52.88 \#,0.00}
- Press F9 to update the field
(with thousand separator and accuracy of 2 decimal places)
Other variations are, for example,
.. \# 0 for rounded whole numbers
.. \# ,0 for rounded whole numbers with a thousands separator
.. \# ,0.00 for numbers accurate to two decimal places, with a thousands separator
.. \# $,0 for rounded whole dollars with a thousands separator
.. \# $,0.00;($,0.00);- for currency, with brackets around negative numbers and a hyphen for 0 values
No comments:
Post a Comment