scientific format specifier 
Author Message
 scientific format specifier

has anyone noticed this :

DEBUG.Print FORMAT(CDBL(1997),"SCIENTIFIC")

2.00E+03

WHAT ??????????????????????????????????????



Fri, 14 Mar 2003 03:00:00 GMT  
 scientific format specifier
"Scientific" defaults to 2 decimal precision.  1.997E+03 rounded up is
2.00E+03
Try:
Debug.Print Format(CDbl(1997), "0.000E+00")


Quote:
> has anyone noticed this :

> DEBUG.Print FORMAT(CDBL(1997),"SCIENTIFIC")

> 2.00E+03

> WHAT ??????????????????????????????????????



Fri, 14 Mar 2003 03:00:00 GMT  
 scientific format specifier

John,

Quote:
>has anyone noticed this :

>DEBUG.Print FORMAT(CDBL(1997),"SCIENTIFIC")

>2.00E+03

What's wrong with it? Looks correct to me.

Matt

============================================

  CodeHound - Free VB Search Engine
  http://www.codehound.com



Fri, 14 Mar 2003 03:00:00 GMT  
 scientific format specifier

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  
 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  
 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


Tue, 18 Mar 2003 03:00:00 GMT  
 
 [ 6 post ] 

 Relevant Pages 

1. Scientific format #'s

2. Best Database Format for Scientific Data?

3. DLL that can generate scientific plot in GIF format

4. Scientific Number Format

5. Public ReadOnly Property - why is specifier needed?

6. Windows' language specifiers

7. Exporting to a CSV file and scientific notation

8. templates for scientific documents?

9. Basic Program For Processing Scientific Data

10. Scientific Formulae ~Howto

11. Basic for Scientific Applications?

12. souroce for scientific shareware?

 

 
Powered by phpBB® Forum Software