number field not accepting % only numbers

[Deleted user]

Hello people,

I am trying to import a field that has a % symbol as numeric and there is no way to import the value as the % symbol is present in the data.
There is a way or a field that I can use to sort out this?.
Thjanks a lot,

[Thomas Deiler]

Dear @[deleted],

values like '10%' are treated as text. So best you import your field to a single line text custom field. Alternatively, you can run a Excel macro over the CSV file to remove the '%'.

So long

Thomas