Excel Sheet Data Loading Issue

[Anonymous]

Hi,

I am loading excel sheet having % and Number Values in Same field After loading number values are also converted into %.How to resolve this I want excel sheet values exactly Number and % values in same  field as in excel.

Please Find the attached Sample excel sheet

Please help me ..

Thanks,

Anusha K

[pokassov]

Hi!

num(your_field)          as your_field

[Kushal_Chawda]

Try loading Field as Text(Field)  as Field and then using Num#( Field  ..) you can separate the % and Number

[#4]

Hi Can you add the sample data

[Anonymous]

Just now added the sample excel.PFA

[Anonymous]

If we give Num function. entire field will convert to number format.I want to be display as it is as excel

[Kushal_Chawda]

Do you want to sow the data as it is or further computation will be done?

[sundarakumar]

The data is not in the correct format in the excel. For two rows it is number and for others it is percentage.

This should be the problem.

Regards,

Sundar

[Anonymous]

Thanks all for responses . I got the result.

[Kushal_Chawda]

So tell us what have you done and mark it as correct answer so that if anyone is facing the same issue will help to resolve the problem