TRUE/FALSE from checkboxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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?
 
Never heard of that, you might want to post this question in the German
Excel newsgroup.


--


Regards,


Peo Sjoblom
 
OK thanks. I wasn't actually aware there were country-specific newsgroups,
but will have a look
 
Back
Top