SUM: MI-L Testing to ensure a string is numeric

Thanks to all who responded to my question: How can I ensure that a value entered into an EditText control of a MB dialog is numeric? The simplest solution was offered by Michael Taylor, Martin Highham, and Robert Crossley: If str$(val(teststring)) = teststring then 'numeric

Re: SUM: MI-L Testing to ensure a string is numeric

Would that algorithm return the correct result if you fed it a numeric string like '0023456', or are numbers with leading zeros not going to be encountered? On Mon, 17 May 2004, Tim.Nuteson wrote: Thanks to all who responded to my question: How can I ensure that a value entered into an