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

--
Regards
Frank Kabel
Frankfurt, Germany

"Gene Solomon" <Gene schrieb im
Newsbeitrag ...
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.