cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MihirY
Level 8

Currency format not displaying zeros after decimal point

I am formatting number to currency with Text(Amount,"[$-en-US]$ ###,###.##")) code. But propblem is if there is a decimal in Amount, then it is displaying properly otherwise it is leaving only with dot.

decimalpoint.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Currency format not displaying zeros after decimal point

Use Text(Amount,"[$-en-US]$ ###,###.00"))

View solution in original post

2 REPLIES 2
Highlighted
Super User
Super User

Re: Currency format not displaying zeros after decimal point

Use Text(Amount,"[$-en-US]$ ###,###.00"))

View solution in original post

Community Support Team
Community Support Team

Re: Currency format not displaying zeros after decimal point

Hi @MihirY,

 

I just tested with the formula @Drrickryp suggested and it worked! Thanks for your sharing @Drrickryp.

Capture.PNG

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,312)