How to display all significant figures?

(0) Share

Report

Posted on by Meneghino

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.

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

AndyPennell on at

Like (2)

Report

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.

Was this reply helpful? Yes No
Meneghino 6,949 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
AndyPennell on at

Like (0)

Report

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.

Was this reply helpful? Yes No