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 | @ |