Select all the cells, use Format./Number, use General, THEN put in your
if-statements. The cells were formatted as text.
Bob Umlas
Excel MVP

"JHL" wrote:

When I download a file off the mainframe I save it as a text file. When I
open the file I use de-limited to get my columns and re-save in Excel format.
However, I cannot use some functions like writing an €œif€� statement.

When I type the €œif€� statement it appears just as I have typed it. What do
I have to do to gain Excels functionality? Thanks