Question

How do I use negative values in number formatting?

  • 29 November 2021
  • 2 replies
  • 170 views

Hey,

I have a lot of field to format in a zap, and most of those fields can be negative. I would like to change their format (switch from “.” separator to “,” but when I use number formatting, it always remove the negative sign before my numbers.

Any ideas on how I could achieve changing the format and keep the negative output?

I checked a lot of ressources, but could not figure how to do so.


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

Hey @GTH! Just checking in here to see if Troy’s suggestion was helpful for what you are trying to achieve. Let us know!

Userlevel 7
Badge +14

Hi @GTH 

Try using Formatter > Text > Replace: https://zapier.com/help/create/format/modify-text-formats-in-zaps#find-replace-or-split-special-characters

Else, you’ll likely have to use a Code step: https://zapier.com/apps/code/help