T Turnipboy Dec 29, 2005 #1 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.
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 Dec 29, 2005 #2 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
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
