IsNum()????

[#1]

Hi,

Why does the IsNum() logical function see 'R54305' and '3E12' as Numbers? Or at least returns 'true' for these values?

Is it seeing the first one as a currency value perhaps? And the second one as coordinates?

Please help, this is screwing me around... [:@]

Thanx!

Hesten-

[hector · Accepted solution]

Hi, well 3e12 it's been read as 3.000.000.000.000, you can check this doing a textbox with this expression num('3E12','#.##0').

the other value, at least for me xD, isn't a number, maybe you can do the same test that i mentioned above, num('R54305','#.##0').... this returns me a null (-) value

rgds

[#3]

Thanks!!!

I just wish I knew why it still sees the other value as a number... oh well...

[#4]

I just tried this in 9, and isnum('R54305') returns 0.

[Oleg_Troyansky]

Hesten,

it's called "scientific notation":

nnnEmmm = nnn * 10 ^ mmm

(where sign ^ means "10 to the power of mmm")

It's used in some scientific applications to represent exceptionally large or exceptionally small numbers.

cheers,

[#6]

Thanks guys.

I also used it on its own and got 0 for isnum(R54305). But somehow, when reading it from source files and being part of other functions, it still saw it as a number and I got -1. But I have found a way around this for my specific solution, so don't worry. Seeing as no one else could reproduce it... I guess we'll leave it there.

Thanks Oleg... these are the kinds of things one forgets while struggling... I got so caught up in the issue that I didn't even think of that...

Thanks.