+3Hello,
I am having trouble with numbers coming from a .CSV.
Currently I have the field set as a Decimal (1.0).
The data in the CSV looks like:
The data when uploaded looks like:
I’ve tried changing formats, but I need it to remain a number format so that I can pull averages.
Thank you,
Lindsay
+3I hope you have solved it in the meantime!
I have problems with importing numbers because the data I have in csv, extracted from the bank site and from paypal, consider the dot as a decimal separator and the comma as a separator for thousands, while airtable reasons the other way around.
The solution I found is to convert the numbers to text format in excel, replace commas with nothing and replace periods with commas and then use the copy/paste function directly on the table.
I hope this solution will be useful to you.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.