Format stripe API

I have the API working and get the dollar value back as 125000 which is then being formated by Adalo as currency as $125,000.00 but it should format as $1,250.00 i have tried the formulas but cant find in documentation how to add a . in two places to get proper formating?

Any ideas?

Can you just divide by 100? Then you can format it as currency usd and it would display how you like.

1 Like

Thanks i can do that as long as all amounts are whole dollars wanted to make sure if i have cents i can still format?

It should keep the decimal places, then just display the number as currency usd.

So simple! Thanks been stuck in a tunel!