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

Community site session details

Session Id :
Power Apps - Building Power Apps
Answered

How to display all significant figures?

(0) ShareShare
ReportReport
Posted on by 6,949

Does anyone know how to display 321.234567891234 in a text box with all significant figures?

According to this post by @AndyPennell, PowerApps does its very best to reproduce Excel (including bugs) however Excel clearly shows all significant figures but PowerApps does not.  If this is true, then this makes PowerApps useless for a lot of scientific work.

Many thanks.

 

__.JPG000.JPG

I have the same question (0)
  • Verified answer
    AndyPennell Profile Picture
    on at
    Re: How to display all significant figures?

    You cannot. PowerApps numbers are limited to the range of values supported by Javascript, and your example exceeds the accuracy limits of same. Excel has a much richer numeric type system.

  • Meneghino Profile Picture
    6,949 on at
    Re: How to display all significant figures?

    Thank you for the reply.

    It would be useful to have in the documentation of PowerApps details of such limitations.

  • AndyPennell Profile Picture
    on at
    Re: How to display all significant figures?

    Indeed, I opened a Document bug to address this when the subject came up last, but it hasn't been fixed yet.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 671 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 424 Super User 2025 Season 2

#3
developerAJ Profile Picture

developerAJ 243

Last 30 days Overall leaderboard