<< Click to Display Table of Contents >> Navigation: Reference > Transforms > Num Format |
Change the number format in one or more columns.
One.
•Check the column(s) you wish to transform.
•Set Format to the new number format (see below).
•For the e, E, and f formats, Precision represents the number of digits after the decimal point. For the g and G formats, Precision represents the maximum number of significant digits (trailing zeros are omitted).
•The following number formats are supported:
Format |
Meaning |
---|---|
e |
Format as [-]9.9e[+|-]999. E.g. 1234567.89 is shown as 1.235e+06. |
E |
Format as [-]9.9E[+|-]999. E.g. 1234567.89 is shown as 1.235E+06. |
f |
Format as [-]9.9. E.g. 1234567.89 is shown as 1234567.89. |
g |
Use e or f format, whichever is the most concise |
G |
Use E or f format, whichever is the most concise |
•Non-numerical values are ignored.
•You can also use Extract and Pad to change the number of characters.