Conversation started Apr 20, 2016 at 4:06.
ThunderFrame
ThunderFrame
Apr 20, 2016 04:06
Note to self. In VBA, IsNumeric("123E45") = True
Comintern
Comintern
@ThunderFrame - That's because Val("123E45") is 123.
Mat's Mug
Mat's Mug
nope. that's because "E" indicates scientific notation ;-) 
?isnumeric("1234A45")
False
Comintern
Comintern
Hmmm...
?IsNumeric("123D45")
True
Mat's Mug
Mat's Mug
get out
I'm puzzled now
Comintern
Comintern
That makes 2 of us.
ThunderFrame
ThunderFrame
Apr 20, 2016 04:10
123D45 = 1.23E+47
Comintern
Comintern
Try this to really screw with you" 
Dim i As Integer
For i = 33 To 126
    Debug.Print i & vbTab & IsNumeric("123" & Chr$(i) & "45")
Next i
Mat's Mug
Mat's Mug 
?val("123D45")
 1.23E+47

?val("123E45")
 1.23E+47
Comintern
Comintern
The , is for internationalizations.
Other than that it's just 'D' and 'd'.
Mat's Mug
Mat's Mug
wtf is that D for.. is that even in the specs?
Comintern
Comintern
LOL!
It's FORTRAN notation.
Mat's Mug
Mat's Mug
Apr 20, 2016 04:17
no way
ThunderFrame
ThunderFrame
Lotus format too?
Comintern
Comintern
Wow, I didn't know chat expanded links.
Examples and other notations
Mat's Mug
Mat's Mug
> FORTRAN also uses "D" to signify double precision numbers
want to edit that to mention that VBA supports it as well? ;-)
Comintern
Comintern
I can't even type tonight. I've been working with 4D databases for so long it's effecting my motor skills.
#shudders#
Also beware of:
?IsNumeric("123" & Chr$(0) & "45")
True
Mat's Mug
Mat's Mug
isn't Chr$(0) a null char?
it's just like it's not there then
Comintern
Comintern
Apr 20, 2016 04:26
No, it terminates the string.
?IsNumeric("123" & Chr$(0) & "Foobar")
True
Mat's Mug
Mat's Mug
oh
oh wow
ThunderFrame
ThunderFrame
I feel an SO question coming on....
 
Conversation ended Apr 20, 2016 at 4:26.