Num Format

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Num Format

Description

Change the number format in one or more columns.

 

Inputs

One.

 

Options

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

 

Notes

Non-numerical values are ignored.

You can also use Extract and Pad to change the number of characters.

 

See also

Date Format