Number format
The Formula Settings dialog offers the same formatting options for both Calc Macro Pro and Calc Macro Classic.
Predefined formats
Section titled “Predefined formats”Select an alias instead of writing a format notation. Each alias is applied as the following Excel format code.
| Alias | Format |
|---|---|
| General | |
| Number | 0.00 |
| Currency | $#,##0.00 |
| Date | yyyy-mm-dd |
| Percentage | 0.00% |
| Fraction | # ?/? |
| Scientific | 0.00E+00 |
| Text | @ |
Pages created with the previous version of the app may carry one of the following aliases. They are still accepted, so migrated macros keep their formatting.
| Alias | Format |
|---|---|
| General Number | #.## |
| Fixed | 0.00 |
| Standard | #,##0.00 |
| Percent | 0.00% |
Custom format
Section titled “Custom format”Enter your own Excel format code in the Custom format field. A custom format overrides the predefined alias.
Please refer to this link to detail formatting.