Graphics

The stats as shown on the Excel sheet do not show up on the Datalinq Field. 

I have a small line that returns NR(Not ranked) if the cell is blank, but other wise returns the value for the players ranking. I can only get the DataLinq field to display the NR's (only text for the column) or the players ranking( only numbers). 

I can't seem to get the column to display both text and numbers. 

It seems simmiler to this issue: https://support.rossvideo.com/hc/en-us/community/posts/360040103251-Strange-Datalinq-issue-

I did try the fix offered here but it did not work. I am using JET not ACE and I am using ADODB datalinq source.

Here is the DataLinq Field. Under F18 you can see the missing numbers and Under F20 you can see the missing text.

Here is the Excel sheet that has the numbers and text under "MARINIERS"

Thank you for any help.

Hi

Try setting the cell format to text. Also try entering data into Excel by prefixing it with an apostrophe ie '

Had the same issue last week!

Simon

I tried setting the cells I had as Text and it didn't work, but later I tried setting the original Data i had to Text it fixed the issues! Thank you a bunch!