Best answer

Format number

  • 28 March 2020
  • 2 replies



I have a a input like : 143 000 €

I would like : 143000

But the formating utility take me 143.000 or 143,000

How to have only 143000


Thanks you in advance for your help



Best answer by jesse 10 June 2020, 19:26

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +11

Hi Seb,

I can see that you’ve received a response from our support team about this question. Can you confirm whether their suggested solution gets you what you need? If so, I can add that here so that others are able to find it if they run into a similar situation :)


Userlevel 7
Badge +9

Hey @Seb, we just wanted to follow-up on this thread. It looks like our support team recommended using the Formatter by Zapier > Text > Replace option.

This way, you can use the "143 000 €" number as the "Input," you can use "€" as the "Find" field, and put nothing in the "Replace" field. This will cause "143 000 €" to turn into "143 000". From there, you could do the same thing with spaces if you then wanted to get that number to “143000”.