Forum Discussion
International nightmare with boolean inputs
I have a static Excel table with records that contain boolean flags. That is, a column populated with values True and False. I wish to assure one of these two values and I hence impose a Data Valid...
ecovonrein Not sure I follow, but I suggest you try to create your dropdown list based on two cells with formulas =TRUE and =FALSE, rather than texts "TRUE" and "FALSE". The formulas should translate to any language supported by Excel. Can't test it though as I only use the English version. See attached and try.
As I wrote, that is my solution for the Data Validation too. I incidentally have the same issue you have. I only have an English Excel. I need to test all this stuff remotely on colleagues' computers.
The biggest problem appears to be though that the translation itself is unreliable. So in theory it could just as well affect your two cells =TRUE and =FALSE.
The biggest problem appears to be though that the translation itself is unreliable. So in theory it could just as well affect your two cells =TRUE and =FALSE.