Number format
Please refer to this link to detail formatting.
You can use the alias instead of format notation for a numeric result of a calculation.
| Alias | Format |
|---|---|
| General | |
| Number | #,##0.00 |
| Currency | $#,##0.00 |
| Date | yyyy/mm/dd |
| Percentage | 0.00% |
| Fraction | # ??/?? |
| Scientific | 0.00E+00 |
| Text | @ |