I setup a workbook with the screen shot "Original Excel File Import".

Setup a new Excel Connection and added a Container using the workbook.

Was able to duplicate your issue.

In the workbook I moved the A/N rows to the top ran a sample and the A/N items showed and the numeric were Null.

So it seems whatever the 1st data row contains (A/N or Numeric) it expects the rest to be the same.

Messed with the Column formats and the Data Expression formats still the same results.

Call Sage Intelligence support with this. Seems to be a "bug"

Sounds like you are on to something.

What happens if you format the data range as a table in the workbook?

As a temporary workaround, what happens when you prefix all values with the apostrophe (') forcing excel to recognize it as text?

Done for the day but will see about these this weekend.

For a work around I created 2 Workbooks and put all the numeric in 1 and all A/N in the other.

Created 2 Connections 1 for each workbook and set up the containers in each.

Created a Union report using 1 Subreport for the Numeric and 1 for the A/N

This worked.

Change the data to a Table still have the issue.

Did the apostrophe just for the Numeric values and that worked.

Easier way is using the Text to Columns on the Data Ribbon.

I highlighted all of the Item Codes. Clicked the Text to Columns button which brings up a Wizard.

Click Next on Steps 1 & 2.

Step 3 change the Column Data Format to Text.

Click Finish.

Save the Workbook.

Change the data to a Table still have the issue.

Did the apostrophe just for the Numeric values and that worked.

Easier way is using the Text to Columns on the Data Ribbon.

I highlighted all of the Item Codes. Clicked the Text to Columns button which brings up a Wizard.

Click Next on Steps 1 & 2.

Step 3 change the Column Data Format to Text.

Click Finish.

Save the Workbook.

You my friend are a gentleman and a scholar. Thank you!

You're welcome. Also thanks to David for the apostrophe trick.

I would also put in a call to Support just to see what they say.