This will round to 3 sig figs =ROUND(A1, 3 - 1 - INT(LOG10(ABS(A1))))
BUT there is no simple way of stopping Excel showing no-sig trailing zeros
That would need a VBA subroutine
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Dave" wrote in message
...
I need to format cells so that they only show 3 significant figures.
1.235 = 1.23
10.25 = 10.3
103.25 = 103
etc