Excel Problem Imported txt file and "If" statements do not work in every cell RRS feed

  • Question

  • Imported a text file

    One colomn has numbers another column has "TRUE"  "False"

    When I us the "If" statement it does not return the correct value of a "1" or "0"

    I type "true" into a cell and then perform an "IF" test  .... =IF(B15="true", 1,0)   it returns a "0"

    The import has done something to the file.

    I have checked and changed the column formating to general and text and nothing changes

    Does anyone know what has gone wrong???

    Wednesday, April 10, 2013 5:22 PM