web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Last two cents in curr...
Power Apps
Answered

Last two cents in currency need to hidden

(0) ShareShare
ReportReport
Posted on by 207

Hi

I'm hoping you can help me. I'd like to find any hidden cents in this column rather than having them display as zeros.
stevenpetersmi_0-1714482622874.png

 I've tried modifying the currency settings, but none of them seem to show the hidden cents. Do I need to access the Power Platform admin settings to resolve this issue? 

 

Thank you.

 

I have the same question (0)
  • Verified answer
    pavanmanideep Profile Picture
    495 Power Up Champ - 2025 on at

    Hi @stevenpetersmi 

     

    You can change the default formatting for number columns, refer to  https://recursion.no/uncategorized/dataverse-remove-decimal-format-from-numeric-columns/

     

    Hope this helps..

     

    If I have answered your question, please mark your post as Solved.

    If you like my response or got a direction forward to proceed, please give it a Thumbs Up at least. Appreciate your Kudos. You can accept more than one post as a solution.

     

    If you were still facing any issue or challenge, please do let me know so that I can try to check for you. Happy to help you further.

     

    Blog: https://ecellorscrm.com

     

    Cheers,

    PMDY

     

  • stevenpetersmi Profile Picture
    207 on at

    Hi

     

    I have follow your step but none of what I want 

     

    stevenpetersmi_0-1714488317697.png

    It won't let me hide the end of two decimal places .00 into hidden format rather than decimal place to Zero

  • Verified answer
    Devvj Profile Picture
    1,132 Super User 2024 Season 1 on at

    Hi @stevenpetersmi 
    There are a couple of places in which you can change the decimal precision and some overwrites the others.
    But one thing that works here atleast is to go in to the currency settings and change the precision on each individual currency there, have you tried that?

    Devvj_0-1714595523792.png

     

    Devvj_1-1714595605093.png


    Hope that helps!

     

  • stevenpetersmi Profile Picture
    207 on at

    Thanks for the reply. Personally, I think it is bad practice for the MS system because they force it all into the environment. After all, one app requests Decimal and another App needs to hide Decimal.

     

    The same goes for removing the comma, as they should allow us to remove a column table/App or the whole environment. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 711 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 319 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard