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

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

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

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

"sharrison" wrote:

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