|
Many people
are confused by Excel documentation showing formulas with different characters
separator
Samtime
they see formulas with "," (comma) and
sometime with ";".(semicolon) Where is the wrong?
There is no
error. Let's see why.
How to change the
character of the argument separator
The
character separator of the Excel formula change with the internation setting of
your Windows installation (may be strange it would be sound)
For
example, if your are in
=MEDIA(B3 ; B4 ; B5 ; B6)
On the
contrary, if you are in
=AVERAGE(B3 , B4 , B5 , B6)
Apart the traduction
that contributes a lot of mesh, we note also that the separator character is
different: it is ";" for
We do not
know why.... (We should ask it to Microsoft...).
But we can
change, if we like, all those useless (and confusing) standard
|
Open the Window Setting panel |
|
|
Click on the International Setting |
|
The
following pop-up will appear. Click the personalization button
|
From this
panel we can change all standard of our system. We must know that these
changes affetc all the Microsoft Office applications: Excel, Word, Outlook,
etc. but do
not affect any other program The first
character is for decimal separator "," instead of "." The
3rd character is for digits groupping
separator "." instead of "," The 8th
charcter is the list separator, that affect also the
argument separator symbol of the Excel formulas. |
