Re: IsNumeric("121d1") = True ??

Tech-Archive recommends: Fix windows errors by optimizing your registry



I was a mathematics major about 22 years ago, but that doesn't mean I know
how to express facts precisely anymore, I guess! When an OP shows a bunch of
numbers all which are positive integers, some expressed in "d" notation, I
say "number of trailing zeros" without even thinking because that is what
they worked out to be in his case: Your additional clarity (and recognizing
the need for it) is appreciated not just by myself, but by all reading the
post I am sure... thanks.

Bill

"Charlie" <Charlie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:704F654F-F6BA-4B01-B745-778BDE44DE23@xxxxxxxxxxxxxxxx
> Let me further my examples to make sure you realize the "d" is not the
> number
> of trailing zeros:
>
> 1.234e5 is equivalent to 1.234 * 10 ^ 5 which equals 123400.
> 1.234d-5 is equivalent to 1.234 * 10 ^ -5 which equals .00001234
>
> yes, you can have negative exponents. In fact, if I recall correctly,
> Fortran also allows decimal exponents (logarithms)
>
> 1.234e5.67 is equivalent to 1.234 * 10 ^ 5.67 which equals 577185.164
> 1.234e-5.67 is equivalent to 1.234 * 10 ^ -5.67 which equals .000002638245
>
> (if I did my math right)
>
> VB doesn't seem to like decimal exponents.
>


.