vba - How to check if string is text or scientific number? -

i curious, if there option in vba check if string text or number in scientific format e.g.(0,212e+01).

i tried isnumeric, val , other functions,but without success. found solution testing middle character , if number, seems bit shabby me.

so question is, if there more reliable solution determine this?

edit:

so steveo40 correct, mistake in decimal separator....

try this...

dim x range set x = range("a1") 'ur cell loking find format  if (x.numberformat = "0.00e+00") msgbox "sceientific" end if