My exact "text" statement is returning a value of 0 for false??

[sharrison]

I am inserting an exact statement in a spreadsheet to verify last names. I
am getting a value of 0 for false and 1 for true. I can not figure out how
to get it to show false and true. thanks

 

[dhstein]

Go to Tools - options - transition and make sure the transitions are unchecked