Different Language Settings...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Trevor Williams - 06 May 2008 10:18 GMT

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

Reply to this Message

Ron de Bruin - 06 May 2008 14:14 GMT

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

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> Dear All
>
[quoted text clipped - 9 lines]
>
> Trevor Williams

Reply to this Message

Ron de Bruin - 06 May 2008 14:19 GMT

> In Dutch for example it will be
>
> =COUNTIF(A1:A10;WAAR)

Must be

=AANTAL.ALS(A1:A10;WAAR)

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> Use it like this
>
[quoted text clipped - 19 lines]
>>
>> Trevor Williams

Reply to this Message

Trevor Williams - 06 May 2008 14:32 GMT

Hi Ron, thanks for the response.
Just for clarification re your last note, Excel will automatically translate
the COUNTIF function too.

Thanks again

Trevor

> > In Dutch for example it will be
> >
[quoted text clipped - 27 lines]
> >>
> >> Trevor Williams

Reply to this Message

Ron de Bruin - 06 May 2008 14:40 GMT

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

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> Hi Ron, thanks for the response.
> Just for clarification re your last note, Excel will automatically translate
[quoted text clipped - 35 lines]
>> >>
>> >> Trevor Williams

Reply to this Message

Trevor Williams - 06 May 2008 15:00 GMT

excellent. Cheers.

Trevor

> Yes
>
[quoted text clipped - 48 lines]
> >> >>
> >> >> Trevor Williams

Reply to this Message