Significant Figures Function nickdb June 8, 2012 at 11:20 PM Re: Significant FiguresTo fix the cell showing 1.0 instead of just 1:Conditionally format your cells so that when =len(a1)=1 changes your formatting to Number w/ 1 decimal point (or however many sig figs you want)