significant digits

B

Bernd P

Hi Ron,

Thanks. You are right.

This should do the trick:
Function nsig(d As Double, l As Long) As Double
'Returns double with l most significant digits of d.
Dim s As String

s = "0." & String(l - 1, "0") & "E+0"
nsig = Format(d, s)
End Function

Regards,
Bernd
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fill with zero 4
Significant digits in double with Format strings? 7
Trailing zeros 5
Excel adds significant digits, resulting in errors in calculations 12
maximum number size/significant digits 4
Format significant digits 6
Number of significant digits allowed in a cell is 15. 2
Machine-readable passport calculations 7

Top