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
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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> 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" <[email protected]> wrote in message
news:%[email protected]...
> "Bernard Liengme" <[email protected]> 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" <[email protected]> wrote in message
news:[email protected]...
> Pardonez moi! I did not want to get into domestic problems!
Bob Phillips wrote...
>Pardonnez-moi? :-)
Qu=E9b=E9cois, pas fran=E7ais?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks