Question

Point to Comma in NUMBERS EUR

  • 30 January 2023
  • 7 replies
  • 56 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

Userlevel 7
Badge +8

Hi @PAAVO 

 

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

in witch Position ...it DON Work ….

Userlevel 7
Badge +8

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

YES.  156.00 > 156,00

 

Userlevel 7
Badge +8

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

Exactly

Userlevel 7
Badge +8

 

You should do it like that then