Hello!
Im trying to use Formatter by Zapier to transform a number without decimals, to a number with decimals.
i.e.
Data in: 6313478
Expected Data Out: 63134,78
Any ideas on how to achieve this?
Thanks!
Hello!
Im trying to use Formatter by Zapier to transform a number without decimals, to a number with decimals.
i.e.
Data in: 6313478
Expected Data Out: 63134,78
Any ideas on how to achieve this?
Thanks!
Hi
You can divide your value by 100 to get the expected result. Use math operation or spreadsheet style formula to do this.
Hi
Try using the Formatter > Numbers > Format Currency option: https://zapier.com/help/create/format/get-started-with-formatter
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.