Posted to microsoft.public.excel.worksheet.functions
|
|
Different Language Settings...
excellent. Cheers.
Trevor
"Ron de Bruin" wrote:
Yes
Also the , will be automatic ;
Only ATP (Analysis ToolPak) functions will not translate
For example Weeknum
This is different in Excel 2007 because the ATP functions are a part of the
default Excel worksheet functions
See this page if you want to know about another problem
http://www.rondebruin.nl/atp.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Trevor Williams" wrote in message
...
Hi Ron, thanks for the response.
Just for clarification re your last note, Excel will automatically translate
the COUNTIF function too.
Thanks again
Trevor
"Ron de Bruin" wrote:
In Dutch for example it will be
=COUNTIF(A1:A10;WAAR)
Must be
=AANTAL.ALS(A1:A10;WAAR)
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Ron de Bruin" wrote in message ...
Use it like this
=COUNTIF(A1:A10,TRUE)
In Dutch for example it will be
=COUNTIF(A1:A10;WAAR)
And all your TRUE's are Waar in the Cells so the formula still work
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Trevor Williams" wrote in message
...
Dear All
What happens to TRUE/FALSE responses if a workbook created on an English
language pc is used on another langauge pc? - particularly in formulae e.g.
=COUNTIF(A1:A10,"=true")
Does the workbook remain in the English language, or convert to the local
language?
Thanks
Trevor Williams
|