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,
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.