View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
William Benson[_2_] William Benson[_2_] is offline
external usenet poster
 
Posts: 230
Default IsNumeric("121d1") = True ??

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" wrote in message
...
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.