Skip to main content

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

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:

Do you think that could work? Let us know! 


Reply