I'm using Excel VBA to validate data submissions in an Excel sheet. One of the tasks is to ensure that the entry is a valid number. The isnumeric() function works just fine for everything except one kind of error.
Sometimes the entry is "23,14" instead of "23.14", both of which isnumeric() returns as True. I've tried intc() and round(), but both of those translate it to 2314. I'd like to be able to flag "23,14" as invalid while leaving "23,141" as valid, of course.