Hello
I tried to make a zap between an excel sheet and Airtable. the problem is that even if I choose “.” or “,”, or change regional parameters, the output of the trigger is always with a “,”
the final result is wrong
example: 0.07 in excel sheet, test trigger give 0,07 and final result is 7 in airtable.
thanks for your help
+12
Hi
It sounds like you’ve done some great detective work to narrow down the cause of this issue!
If the information is coming from Excel in the wrong format then that’s where we need to address the issue. You said that you changed the regional parameters, which is what I would recommend, it sounds like that hasn’t stuck for some reason. Could you try both changing the overall sheet settings and also highlighting each column with numbers in and formatting them all individually? I know it sounds like overkill but apps like Excel and Google Sheets can be very stubborn when it comes to formatting.
If that doesn’t work, you could try creating a whole new sheet, setting all the formatting the way you want to and then pasting the values in from your original sheet.
I hope that helps, I know how frustrating it is when you’re trying to get spreadsheet apps to do what you need for formatting!
+8
Hi
In addition to what
This is a great resource to check out for this part.
https://zapier.com/help/create/format/modify-number-formats-in-zaps
IF this works, then it seems to be a problem with the Excel data.
Let us know if this works :)
+7
hey there
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
