Different Language Settings...

  • Thread starter Thread starter Trevor Williams
  • Start date Start date
T

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
 
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
 
Hi Ron, thanks for the response.
Just for clarification re your last note, Excel will automatically translate
the COUNTIF function too.

Thanks again

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
 
excellent. Cheers.

Trevor

Ron de Bruin said:
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
Click to expand...
 
Back
Top