It is clearly an odd bug
isnumeric("123E456") is also True but isnumeric("123DE456") is False...
Maybe there is a confusion with Hexadecimal numbers? But A,B,C and F is also
False...
Anyone has a clue?
Regards,
Pedro
On Thursday 23 June 2022 14:26:33 (+01:00), Lucien Mathay wrote:
>
> Le 23/06/22 à 14:53, Dave a écrit :
> > Try =ISNUMBER("123D456") instead of =ISNUMERIC("123D456")
> Thank you and sorry, Dave, I forgot to specify that the question was related
> to Basic. ( msgbox ISNUMBER("123C456") sends "Basic error - function not
> defined" )
>
> In Basic thus, msgbox isnumeric("123D456") returns True, although it
> should return False, if I am not wrong ?
>
> Lucien
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>
--
Sent with Vivaldi Mail. Download Vivaldi for free at vivaldi.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
