mistakes in the Excel functions (help on line french version at le
 

correct the formulas in the help on line (replace commas by semicolons).
indeed the functions do not work because of this mistake
e.g. the SOMME (in french, for SUM) function argument has separators as
coma, and should be semi colon

IS this a question or a statement?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"sergeK" wrote in message
...
correct the formulas in the help on line (replace commas by semicolons).
indeed the functions do not work because of this mistake
e.g. the SOMME (in french, for SUM) function argument has separators as
coma, and should be semi colon

As I understand it, the separator for function arguments is:
1) a comma for county version where the decimal separator in numbers is a
period, and
2) a semi-colon for local version where the comma is used as the decimal
separator in numbers
So in France one-and-a-half Francs is written as 1,50, so semi-colons are
used in functions but in UK, US, Canada, Australia, NewZeeland etc where we
write 1.50 then commas are used in function.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"sergeK" wrote in message
...
correct the formulas in the help on line (replace commas by semicolons).
indeed the functions do not work because of this mistake
e.g. the SOMME (in french, for SUM) function argument has separators as
coma, and should be semi colon

"Bernard Liengme" wrote...
....
used in functions but in UK, US, Canada, Australia, NewZeeland etc where we
write 1.50 then commas are used in function.
....

Aussi en Québec?

Pardonez moi! I did not want to get into domestic problems!

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Harlan Grove" wrote in message
...
"Bernard Liengme" wrote...
...
used in functions but in UK, US, Canada, Australia, NewZeeland etc where
we
write 1.50 then commas are used in function.
...

Aussi en Québec?

Pardonnez-moi? :-)

"Bernard Liengme" wrote in message
...
Pardonez moi! I did not want to get into domestic problems!

Bob Phillips wrote...
Pardonnez-moi? :-)

Qu=E9b=E9cois, pas fran=E7ais?