| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Different Language Settings...
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Different Language Settings...
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Different Language Settings...
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Different Language Settings...
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Different Language Settings...
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 |
|
#6
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change German language data into Eglish Language in a colum | Excel Discussion (Misc queries) | |||
| Right to Left sorting without changing language settings | Excel Discussion (Misc queries) | |||
| Eliminating default language settings to all Office 2003 apps. | Excel Discussion (Misc queries) | |||
| excel language settings/cell format | Excel Discussion (Misc queries) | |||
| override language settings on date | Excel Discussion (Misc queries) | |||
Linear Mode
