HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Building Reports Using the Web Intelligence Java Report Panel (August 2008)

Formatting numbers and dates204
Formatting cells displaying number and currency data
Character(s) Display(s) Example
# The corresponding
digit. If the number has
less digits than the
number of # characters
used to specify the
format, no leading
zeros are inserted.
‘12345’ with the
format:
#,##0 gives ‘12,345’
(if your locale defines
the grouping separator
as a comma) or ‘12
345’ (if your locale
defines the grouping
separator as a space)
0 The corresponding
digit. If the number has
less digits than the
number of 0 characters
used to specify the
format, a leading
zero(s) is inserted
before the number.
‘123’ with the format
#0,000 gives ‘0,123’
, The grouping separator
as defined by your
locale.
‘1234567’ with the
format:
#,##0 gives
‘1,234,567’ (if you
locale defines the
grouping separator as
a comma) or ‘1 234
567’ (if your locale
defines the grouping
separator as a
non-breaking space)
. The decimal separator
as defined by your
locale.
‘12.34’ with the
format:
#.#0 gives ‘12.34’ (if
your locale defines the
decimal separator as a
period) or ‘12,34’ (if
your locale defines the
decimal separator as a
comma)