cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Meneghino Community Champion
Community Champion

How to display all significant figures?

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

1 ACCEPTED SOLUTION

Accepted Solutions
Power Apps
Power Apps

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.

View solution in original post

3 REPLIES 3
Power Apps
Power Apps

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.

View solution in original post

Meneghino Community Champion
Community Champion

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.

Power Apps
Power Apps

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.

Helpful resources

Announcements
secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (7,019)