Hello all :D
I need to convert an amount in euros, that is written numerically, into french text, in an googlesheet.
I know there is a formula (=NUMBERTEXT;lang) that allows me to do it with googlesheet, but I cannot find the way to make it wrk with Zap, for Zap to automatically make the move.
Can you help me, please ?
Many thanks
Question
How do I convert a numerical amount in Euros to French text in Google Sheets using Zapier?
- Beginner
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
- Beginner
I also found this formula for Zap, that could hep :
VALUE(text): Returns the text converted to a numeric value
> What I would need is, in fact, the opposite of that formula = to convert a numeric value to a text
+11- Community Manager
Hi
It’s possible to use formulas directly in a Google Sheets action, for example:
It seems the NUMBERTEXT formula is available through installing an add-on for Google Sheets. I’ve not got that add-on installed but if you have then I’d have thought that you could just use that NUMBERTEXT formula directly in the Google Sheets action and the add-on should handle the rest.
Want to give that a try and see if that approach does the trick?
If not, you may need to look at using a Code by Zapier action to handle the conversion. It’s a bit advanced but we have an AI feature that can help to generate the code for you. See our Generate a Code step using AI (Beta) guide for more details.
- Beginner
@clem, Another option is to use Tuulio.
It has a ready-to-use action that turns a number into text.
Number: 212.0 → Text: two hundred and twelve euro, zero cents
It takes no more than 3 minutes to set it up.
Feel free to reach out in case you need assistance.
👋
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.