I have a weird problem with custom-formatting MS Excel 2010.
I am just trying to make formatting of custom number, for example 110,5
should be shown as 110.5
, but there is my problem:
#.#
or any other combination like #"."#
or 0.0
or #.0
or #"."0
doesn't work at all.
On Office page I found it should be : #.0#
but any combination of dot .
without " "
tags doesn't work and Office keep telling that he can't use this format.
Any idea how to make formatting of any numbers in this format (#.#
)?
,
is being used as a decimal mark while in English speaking countries dot.
is being used for this purpose. This behaviour is influenced by the locale (internationalization) setting of the computer.