I can't find a MATCH in a column imported from a Sharepoint List

[timm1216]

Hi -

I'm scratching my head on this one ...

I pulled in a sharepoint list into an excel file (see attached) and stored it as a table.

And, I can't MATCH any of the values on a lookup!

But, when I double click on one of the cell contents, the data shifts to the right of the cell at which point it presto! The cell data becomes "matchable".

So, when the data is brought in from Sharepoint, it is in a state where I can't MATCH the data in a cell. 

Anyone have any ideas ?

[#2 · Accepted solution]

The data in your file is text, not numbers. Were you expecting to find a number?  If so, then you need to convert those values from  text to number format.

[#3]

I see ...

The format of the data I was attemting to match was "General".

When I changed it to text, I was able to find the match.

Also, I see that when I double clicked the cell, it actually converted the format to a number.

Thanks for the tip. That's all I needed :)