| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
TRUE/FALSE from checkboxes
In Germany, the words false / true (falsch / wahr), based from checkboxes,
are written in lower case letters, and Excel doesn't 'read' it as a boolean. When I doubleclick on the cells "Falsch" and "Wahr" and then press enter, the word changes the notation to capital letters. (e.g. "FALSCH"). After this the calculation works ok. I think that is a problem with the German and English settings. Anyone have any ideas please? thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
TRUE/FALSE from checkboxes
Sounds like Excel thinks the values are text and the double click corrects
it. I don't understand what you mean by "problem with the German and English settings"? What has English settings to do with this? Are you using a German version of Excel on a PC with a German OS? -- Regards, Peo Sjoblom "Phil Davy" wrote in message ... In Germany, the words false / true (falsch / wahr), based from checkboxes, are written in lower case letters, and Excel doesn't 'read' it as a boolean. When I doubleclick on the cells "Falsch" and "Wahr" and then press enter, the word changes the notation to capital letters. (e.g. "FALSCH"). After this the calculation works ok. I think that is a problem with the German and English settings. Anyone have any ideas please? thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
TRUE/FALSE from checkboxes
Hi,
thanks for yr email. Sorry for clarification, a spreadsheet was written in England, but the German branch of the company are using it. Does this help? "Peo Sjoblom" wrote: Sounds like Excel thinks the values are text and the double click corrects it. I don't understand what you mean by "problem with the German and English settings"? What has English settings to do with this? Are you using a German version of Excel on a PC with a German OS? -- Regards, Peo Sjoblom "Phil Davy" wrote in message ... In Germany, the words false / true (falsch / wahr), based from checkboxes, are written in lower case letters, and Excel doesn't 'read' it as a boolean. When I doubleclick on the cells "Falsch" and "Wahr" and then press enter, the word changes the notation to capital letters. (e.g. "FALSCH"). After this the calculation works ok. I think that is a problem with the German and English settings. Anyone have any ideas please? thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
TRUE/FALSE from checkboxes
Never heard of that, you might want to post this question in the German
Excel newsgroup. -- Regards, Peo Sjoblom "Phil Davy" wrote in message ... Hi, thanks for yr email. Sorry for clarification, a spreadsheet was written in England, but the German branch of the company are using it. Does this help? "Peo Sjoblom" wrote: Sounds like Excel thinks the values are text and the double click corrects it. I don't understand what you mean by "problem with the German and English settings"? What has English settings to do with this? Are you using a German version of Excel on a PC with a German OS? -- Regards, Peo Sjoblom "Phil Davy" wrote in message ... In Germany, the words false / true (falsch / wahr), based from checkboxes, are written in lower case letters, and Excel doesn't 'read' it as a boolean. When I doubleclick on the cells "Falsch" and "Wahr" and then press enter, the word changes the notation to capital letters. (e.g. "FALSCH"). After this the calculation works ok. I think that is a problem with the German and English settings. Anyone have any ideas please? thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
TRUE/FALSE from checkboxes
OK thanks. I wasn't actually aware there were country-specific newsgroups,
but will have a look "Peo Sjoblom" wrote: Never heard of that, you might want to post this question in the German Excel newsgroup. -- Regards, Peo Sjoblom "Phil Davy" wrote in message ... Hi, thanks for yr email. Sorry for clarification, a spreadsheet was written in England, but the German branch of the company are using it. Does this help? "Peo Sjoblom" wrote: Sounds like Excel thinks the values are text and the double click corrects it. I don't understand what you mean by "problem with the German and English settings"? What has English settings to do with this? Are you using a German version of Excel on a PC with a German OS? -- Regards, Peo Sjoblom "Phil Davy" wrote in message ... In Germany, the words false / true (falsch / wahr), based from checkboxes, are written in lower case letters, and Excel doesn't 'read' it as a boolean. When I doubleclick on the cells "Falsch" and "Wahr" and then press enter, the word changes the notation to capital letters. (e.g. "FALSCH"). After this the calculation works ok. I think that is a problem with the German and English settings. Anyone have any ideas please? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search for 2 true arguments and return true or false | Excel Discussion (Misc queries) | |||
| Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
| Reverse false and combine with true true value | Excel Worksheet Functions | |||
| True/False | Excel Worksheet Functions | |||
| Macro to make all checkboxes false and clear all comboxes | Excel Discussion (Misc queries) | |||
Linear Mode
