File Download loses Excel features

  • Thread starter Thread starter JHL
  • Start date Start date
J

JHL

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 Excel’s functionality? Thanks
 
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
 
It sounds as if your cell is formatted as text, so that's why it's not
evaluating the formula. Format the cell as General, and either re-enter
your formula, or F2 and enter.
 
Thank you both. That worked.

David Biddulph said:
It sounds as if your cell is formatted as text, so that's why it's not
evaluating the formula. Format the cell as General, and either re-enter
your formula, or F2 and enter.
Click to expand...
 
Back
Top