Re: IsNumeric("121d1") = True ??
- From: "William Benson" <wbenson1(SPAMSUCKS)@nycap.rr.com>
- Date: Thu, 30 Jun 2005 01:18:04 -0400
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.
>
.
- References:
- IsNumeric("121d1") = True ??
- From: jjk
- Re: IsNumeric("121d1") = True ??
- From: William Benson
- Re: IsNumeric("121d1") = True ??
- From: Charlie
- Re: IsNumeric("121d1") = True ??
- From: Charlie
- IsNumeric("121d1") = True ??
- Prev by Date: Re: FIND in only one column
- Next by Date: Re: Problem in compiling code containing "$" char
- Previous by thread: Re: IsNumeric("121d1") = True ??
- Next by thread: Re: IsNumeric("121d1") = True ??
- Index(es):