Microsoft Office Tutorials and References
In Depth Information
Formatting Fields with Field Properties
Table 2-3 (conti nued)
Number Format
How It Works
Fixed
Displays numbers with the number of decimal places
specified in the Decimal Places property (immediately after
the Format property; the default is 2 )
Standard
Displays numbers with commas as thousands separators
and the number of decimal places specified in the Decimal
Places property
Percent
Displays numbers as percentages — that is, multiplied by
100 and followed by a percent sign
Scientific
Displays numbers in scientific notation
The Field Size property can affect the format. Choose a field size large
enough to display your data in the desired format.
You can define your own number format by using the following symbols:
Symbol
What It Does
#
Displays a value if one is entered for that place
0
Displays 0 if no value appears in that place
.
Displays a decimal point
,
Displays a comma
$ (or other currency symbol)
Displays the currency symbol
%
Displays the number in percent format
E+00
Displays the number in scientific notation
To create a number format with comma separators and three decimal
places, type the following: ###,##0.000 .
You can define a numeric format so that the format depends on the value.
You can define formats for positive and negative numbers, for zero, and
for null values (when no value is entered). To use this feature, enter a
fourpart format in the Format property, with the parts separated by commas.
The first part is for positive numbers; the second is for negatives; the third
is used if the value is 0; and the fourth is used if the value is null (such as
#,##0; (#,##0); “—”; or “none”). Using this type of format, you can display
positive and negative numbers in different colors, if you like, such as positive
in green and negative in red. Put the desired color in square brackets in the
correct section of the expression. The available colors are black, blue, green,
Search JabSto ::




Custom Search