Prevent Excel from defaulting "True" and "False" to boolean

Question

My Excel document defaults all True and False strings to TRUE and FALSE, which it then treats as a boolean value and this is failing in my macro.

I can right click -> format cells -> select text, but I don't know which cells users will use, so this method will not work.

Is there a global method to disable this automatic conversion or perhaps a method using VBA?

Answer 1

Solved the problem through another method and just formatted all cells as Text