MrShorty,
No, some cells will have the numbers like 236548 and some others 0.38649. I
wanted to see if there is a common function that can be used to return 3 (or
4) significant numbers.

Thanks

Raj

"MrShorty" wrote:


Raj:

Are all your values of the same magnitude (0.0xxxxx)? If so, you could
use a 0.0000 number format or ROUND(a1,4), similar to what Paul
suggested.

If not, then the easiest way I know of to get three sig figs is to use
a scientific number format (0.00E+0), but a lot of people are either
uncomfortable with exponential notation or for some other reason it
isn't desirable.

A function like ROUND(A1,INT(LOG(A1)-2) will return a number to three
significant figures regardless of the magnitude. It will even take a
number like 1234.5 and return 1230. But it won't display significant
0's after the decimal point (eg a number like 0.13014 returns 0.13.
If this solution is the most desirable, I'm sure we could come up with
a way of dealing with this case to make this work properly.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=481908