I'm trying to incorporate a cell within an "IF" formula and the cell contains a number (2000) but its formatted as text instead of a number. This is due to the way it exports out of my system in excel. When use an =IF(A1="2000",.... its not recognizing the 2000 since its text and not a number. If I convert it to a number the formula will work but I don't want to have to convert it to a number every time.
How can I write the formula to recognize the text?
Thanks!
Bookmarks