Hi ! I have a zap who transfert data of a row from an excel worksheet to a table in caspio. My problem is the number with comma in excel don't transfert correctly. Example: 3,5 in excel become 35 in caspio table.
Someone can help me ?
Thanks in advance
Sebastien
+6Hey there
Welcome to the Community! 🎉
Before we dig deeper into this, could you please a detailed screenshot with how your Zap is configured? Please don’t include/blur out any personal information in the screenshot.
Thanks! 😊
This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.
THIS IS MY ZAP
AND WATCH HOW IT FINISHES IN MY CASPIO TABLE:
+9Hey there,
Hmm, I wonder if it has something to do with the number format being used in the Excel sheet? Here’s a similar question that uses a Formatter step as a possible solution:
Do you think that could work? Let us know!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
