Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • How do I convert a numerical amount in Euros to French text in Google Sheets using Zapier?

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 
 

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 

Hi @clem, welcome to the Community! 👋

It’s possible to use formulas directly in a Google Sheets action, for example:
24cbee5624c799d41be65d5af7e1d4c6.png

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.

Hi @clem, Code step is an option if you know JavaScript or Python.

@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.

👋

@clem Is this what you need? It's also supporting French. ^^

Thank you @Iliyan Slavov but I was searching for a free solution, not one at 20USD/year. I already have to pay for Zap, I would prefer to not multiply the cost. 
Many thanks anyway ! 

Terms & Conditions