Power pivot

[BORUCH]

Hi all

can someone help explain to me this problem

I have a table that I’m trying to import to power pivot the first column of that table has my invoice number and credit memo numbers all together by customer

for example, column 1 would look like this [TABLE="width: 500"]
<tbody>[TR]
[TD]INVOICE#/CREDIT MEMO #[/TD]
[TD]CUSTOMER#[/TD]
[TD]AMT [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]70001[/TD]
[TD]A001[/TD]
[TD]$100[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]X1000[/TD]
[TD]A001[/TD]
[TD](-36.00)[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


When I import this table to power pivot it ignores the credit memos that start with x it just shows blank

Why is that