Question

How to add decimal separator to a number with no separators?

  • 6 January 2022
  • 2 replies
  • 344 views

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!

 


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 +14

Hi @Nicotlan 

Try using the Formatter > Numbers > Format Currency option: https://zapier.com/help/create/format/get-started-with-formatter

Userlevel 7
Badge +9

Hi @Nicotlan 

You can divide your value by 100 to get the expected result. Use math operation or spreadsheet style formula to do this.