Significant figures (not decimal places)

[Guest]

Is there a way to display numbers with 3 significant figures? For instance,
display 1367 as 1370, 14621 as 14600, and .02637 as .0264.

I'm trying to find a way to take a column of data, and then display it with
3 sig figs. Will any functions or macro help me out?

Thanks.

 

[Frank Kabel]

Hi
see:
http://www.mcgimpsey.com/excel/formulae/sigfigs.html

 

[Ron Rosenfeld]

On Thu, 9 Dec 2004 09:53:12 -0800, Gene Solomon <Gene

Is there a way to display numbers with 3 significant figures? For instance,
display 1367 as 1370, 14621 as 14600, and .02637 as .0264.

I'm trying to find a way to take a column of data, and then display it with
3 sig figs. Will any functions or macro help me out?

Thanks.

Do you really mean "display" or do you mean "change to" a number with n
significant digits.

If you want to change the number to have only n significant digits, then the
formula:

=ROUND(A1,SigDigits-1-INT(LOG10(ABS(A1))))

will do that.

If you want to keep the original number, but adjust the formatting so only
three significant digits are displayed, I don't believe that is possible.


--ron