Problems load data from excel

[#1]

Hi All

I have a problem loading some data from excel. I try to load these data.

Distribution Cost		Month Actual	Month Budget	Month l/y	Index Budget	Index l/y
Denmark	kDKK	1.289	1.745	1.507	74	86
Denmark	% Act	2,35%	2,99%	2,66%
Denmark	% T/O	1,00%	1,30%	1,20%
Denmark	Cost/m3	72	90	79	80	90
Denmark	Cost/m3 C.	71	88	79	81	89
Denmark	Km	159	155	158	103	101

But when I load the data I can not see the %-figures, but I ca find the text called % Act. Can somebody tell me why and what to do for solve it? (see report output in file)

Best regards

Bjarne

[jagannalla]

That's y i asked you to provide sample data wt you have now. B'coz if i take the data in inline i can also see the result.

[kji]

Looking at your table it looks like the numbers with the % is imported as text (they are left adjusted in the column), maybe the original poster was using a numeric expression on the field.

[whiteline]

maybe the original poster was using a numeric expression on the field

Exactly.

So

Its hard to help without looking to your script