Additional Format Dialog Box (Data Extraction)

DATAEXTRACTION (Command) Find: Refine Data (Page 5 of 8) > Right-click over a data cell > Set Column Data Format > Choose a data type other than Date, General, or Text > Additional Format

List of Options

The following options are displayed.

Current Value

Displays the value in base drawing units.

Preview

Displays updates to the format as you change the conversion factor and other settings.

Conversion Factor

Specifies the conversion factor to use on the current value. The default is 1 for no conversion.

Additional Text

Specifies a prefix or a suffix for the value.

Number Separators

Specifies a decimal separator and the formatting for numbers over 1000.

  • Decimal

    Specifies the separator for decimal values. Select a period, a comma, or a space.

  • Thousands

    Inserts a comma to group thousands in a field value.

Zero Suppression

Controls the suppression of leading and trailing zeros, and of feet and inches that have a value of zero.

  • Leading

    Suppresses leading zeros in all decimal values. For example, 0.5000 becomes .5000.

  • Trailing

    Suppresses trailing zeros in all decimal values. For example, 12.5000 becomes 12.5, and 30.0000 becomes 30.

  • 0 Feet

    Suppresses the feet portion of a feet-and-inches value when the distance is less than one foot. For example, 0'-6 1/2" becomes 6 1/2".

  • 0 Inches

    Suppresses the inches portion of a feet-and-inches value when the distance is an integral number of feet. For example, 1'-0" becomes 1'.