Hi there @Waggie,

It looks like we’re going to need the Code by Zapier step for this to be possible. I asked ChatGPT about the code that we’re going to use and here’s how to achieve this:

1. Add the Code by Zapier action step.
2. Choose the “Run Javascript” event.
3. Type “Number” in the “Input Data” field and map the number to the right field.
4. Copy and paste this code to the “Code” field:
   const originalNumber = inputData.number; // Assuming 'number' is the field with your amount // Replace Dutch format with US format // First remove the period used for thousands, then replace the comma with a period let formattedNumber = originalNumber.replace(/\./g, '').replace(/,/g, '.'); output = ({formattedNumber}];
   
   (view larger)
    
5. Here’s the result:
   
   (view larger)

Hopefully, this helps!

Hello Ken.A,

Thx for your response! I just found a easier way to do this. See printscreen, now it works!

Action you need to change to Format number and then you can choose to switch a Comma for grouping and period for decimal!

That’s really awesome @Waggie! You’re definitely correc! Using Numbers in Formatter by Zapier is easier.

Also, thank you for sharing your solution here. I really appreciate it!

Happy Zapping!