Different Language Settings...

[Trevor Williams]

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

 

[Ron de Bruin]

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

 

[Ron de Bruin]

In Dutch for example it will be

=COUNTIF(A1:A10;WAAR)

Must be

=AANTAL.ALS(A1:A10;WAAR)

 

[Trevor Williams]

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]

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

 

[Trevor Williams]

excellent. Cheers.

Trevor

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