Skip to main content
Question

Point to Comma in NUMBERS EUR

  • January 30, 2023
  • 7 replies
  • 311 views

I created a ZAP with which I import ORDERS from Shopify into Google Spread, the problem now is that the EUR information ends with "." instead of ",2 flow in, how can I optimize that in the ZAP? I've already tried FORMATTER, but I can't get it right.

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

7 replies

MohSwellam
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+8
  • Zapier Orchestrator & Solution Partner
  • January 30, 2023

Hi @PAAVO 

 

You can use the formatter to replace the period with a comma. What was the issue doing that?


  • Author
  • New
  • January 30, 2023

in witch Position ...it DON Work ….


MohSwellam
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+8
  • Zapier Orchestrator & Solution Partner
  • January 30, 2023

Im a bit confused. It already shows the number with a decimal place? Shouldn't it show it as 536,80 ? 


  • Author
  • New
  • January 30, 2023

YES.  156.00 > 156,00

 


MohSwellam
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+8
  • Zapier Orchestrator & Solution Partner
  • January 30, 2023

You should use Text instead of Number and make it replace the “.” with “,” (if I understand you correctly)


  • Author
  • New
  • January 30, 2023

Exactly


MohSwellam
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+8
  • Zapier Orchestrator & Solution Partner
  • January 30, 2023

 

You should do it like that then