2012

Table Of Contents

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'.

Edit Formula Column Dialog Box

Quick Reference