Significant figures

T

Turnipboy

How do I get a number to be displayed in say 2 significant figures, all
that I find in numbers formating is decimal places.

Thanks.
 
B

Bernard Liengme

From an earlier reply by Jerry W. Lewis
=ROUND(A1, A2 - 1 - INT(LOG10(ABS(A1))))
note that you may get non significant trailing zeros
best wishes
 
Top