View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme
 
Posts: n/a
Default how do i format a cell in Excel to 3 significant numbers

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