Raj Wrote:
If I have a number 0.0246589
and would like to get the 3 significant digits, what would be the
function
to use?
The function (=round("cell"3-LEN(INT("cell")))) works for numbers above
zero.

Thanks in advance

Hi Raj

If the 0.0246589 is in cell A1 in B1 put =ROUND(A1,3), this returns a
vlue of 0.025


--
Paul Sheppard


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