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: qa-unsubscr...@openoffice.apache.org > For additional commands, e-mail: qa-h...@openoffice.apache.org > > -- Sent with Vivaldi Mail. Download Vivaldi for free at vivaldi.com --------------------------------------------------------------------- To unsubscribe, e-mail: qa-unsubscr...@openoffice.apache.org For additional commands, e-mail: qa-h...@openoffice.apache.org