Num Format

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Num Format

Description

Change the number format in 1 or more columns.

 

Inputs

1

 

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

Format as [-]9.9E[+|-]999

f

Format as [-]9.9

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 Truncate and Pad to change the number of characters.

 

See also

Date Format