Hi
I am having trouble importing number fields from an Excel file. In my form I have two Number fields, one for the ID number and the other for the phone number. In the excel file the columns are defined as number columns and they have numbers like 1144035567 for ID´s and 3155467898 for phone number´s for example. When I want to Import the file I get an error alert for this two fields saying that those are invalid numbers for numeric fields.
The numbers in the excel file are not decimal numbers and I already set enough digits in zoho for this number fields.
Row 2 Col 2 - Value '1.114818221E9' is not a valid 'Number'
Row 2 Col 10 - Value '3.153139176E9' is not a valid 'Number'
How can I fix this? or how should I configure the number fields in order to avoid this?
or how should I configure the column propperties in Excel?
Any help will be appreciated