sounds pretty worthless to me. why bother with scientific notation if you are always going to drop your precision to 3?
well, i guess it's irrelevant in the real world. just roll your own format string.
Quote:
>"Scientific" defaults to 2 decimal precision. 1.997E+03 rounded up is >2.00E+03 >Try: >Debug.Print Format(CDbl(1997), "0.000E+00")
>> has anyone noticed this :
>> DEBUG.Print FORMAT(CDBL(1997),"SCIENTIFIC")
>> 2.00E+03
>> WHAT ??????????????????????????????????????
Sun, 16 Mar 2003 03:00:00 GMT
Tore #5 / 6
scientific format specifier
Scientific format is mainly useful with very large or very small numbers to make them more readable or to reduce the amount of real estate needed to display them. YOU decide what precision you want. 3 was an example...
HTH, Tore.
Quote:
> sounds pretty worthless to me. why bother with scientific notation if you > are always going to drop your precision to 3?
> well, i guess it's irrelevant in the real world. just roll your own format > string.
> >"Scientific" defaults to 2 decimal precision. 1.997E+03 rounded up is > >2.00E+03 > >Try: > >Debug.Print Format(CDbl(1997), "0.000E+00")
> >> has anyone noticed this :
> >> DEBUG.Print FORMAT(CDBL(1997),"SCIENTIFIC")
> >> 2.00E+03
> >> WHAT ??????????????????????????????????????
Mon, 17 Mar 2003 03:00:00 GMT
John Herbste #6 / 6
scientific format specifier
Quote:
> Sounds pretty worthless to me. > Why bother with scientific notation if you > are always going to drop your precision to 3?
John G, Would you rather write the wavelength of green light as 0.000000550 meters or 5.55E-7 meters or the number of atoms in a whatever as about 1,000,000,000,000,000,000,000 or 1E21? Regards, JohnH
scientific format specifier