Reference Guide

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)