Engineering format

This format expresses numbers so that they are always expressed in the neatest possible format with the standard SI abbreviations giving you the size of the number. To do this, choose the definition

g0.##

from the predefined list in the Number formats box.

It will probably be useful to add the appropriate suffix for the measurement, e.g. "m" for distance in metres.