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
Page 1 / 1
Hey there @SEBASTIEN_JOSEPH,
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:
Hey there, @SEBASTIEN_JOSEPH! Thanks for reaching out in community.
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: