We have a software package from which we can export data (numbers and text)
to MS Excel. When i try an run a simple "IF" formula on the imported data,
excel always returns a negative result.
For example, the imported data cell has content "name00", and i put in a
regular IF formula to use this data, it is never recognized as *true*. If i
manually re-type the information into the cell then it is picked up - and a
*true* result is returned!
If i paste special the data into excel i get the option of unicode or text,
or i have the choice to export the data directly. None of these three options
has helped and i am left unable to use the data i require!
would be grateful of any ideas.