Significant figures

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.

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

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Turnipboy" <Turnipboy.20sznm_1135862700.5196@excelforum-nospam.com> wrote
in message news:Turnipboy.20sznm_1135862700.5196@excelforum-nospam.com...
>
> 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.
>
>
> --
> Turnipboy
> ------------------------------------------------------------------------
> Turnipboy's Profile:
> http://www.excelforum.com/member.php...o&userid=24527
> View this thread: http://www.excelforum.com/showthread...hreadid=496623
>