| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup if statement returning a "false" answer. | Excel Worksheet Functions | |||
| Nested If Statement "FALSE" Return | Excel Worksheet Functions | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Formula Returning "FALSE" | Excel Worksheet Functions | |||
Hybrid Mode
