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.
Userlevel 7
+8
- Certified Zapier Expert
- 757 replies
-
30 January 2023
Hi
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
+8
- Certified Zapier Expert
- 757 replies
-
30 January 2023
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
+8
- Certified Zapier Expert
- 757 replies
-
30 January 2023
You should use Text instead of Number and make it replace the “.” with “,” (if I understand you correctly)
Exactly
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.