Set Field Options Dialog Box

The Set Field Options dialog box The units for a specific attribute without affecting the units used by other attributes or globally.

To use the Set Field Options dialog box, right-click any numerical field that has units, then select Units and Formatting.

Value	Displays the value of the currently selected item.
Unit	Displays the type of measurement. To change the unit, select the unit you want to use from the drop-down list. This option also lets you use both U.S. customary and S.I. units in the same worksheet.
Display Precision	Sets the rounding of numbers and number of digits displayed after the decimal point. Enter a negative number for rounding to the nearest power of 10: (-1) rounds to 10, (-2) rounds to 100, (-3) rounds to 1000, and so on. Enter a number from 0 to 15 to indicate the number of digits after the decimal point.
Format	Lets you select the display format used by the current field. Choices include: Scientific —Converts the entered value to a string of the form "-d.ddd...E+ddd" or "-d.ddd...e+ddd", where each 'd' indicates a digit (0-9). The string starts with a minus sign if the number is negative. Fixed Point —Abides by the display precision setting, and automatically enters zeros after the decimal place to do so. With a display precision of 3, an entered value of 3.5 displays as 3.500. General —Truncates any zeros after the decimal point, regardless of the display precision value. With a display precision of 3, the value that would appear as 5.200 in Fixed Point format displays as 5.2 when using General format. The number is also rounded. So, an entered value of 5.35 displays as 5.4 regardless of the display precision. Number —Converts the entered value to a string of the form "-d,ddd,ddd.ddd...", where each 'd' indicates a digit (0-9). The string starts with a minus sign if the number is negative. Thousand separators are inserted between each group of three digits to the left of the decimal point.