Hi all, I'm trying to validate a number field that has to be exactly six digits and
cannot start with a zero:
"^[1-9][0-9][0-9][0-9][0-9][0-9]$"
Is there any other way to do this?
Thanks,
Roy
.
Re: JSP form beginner question ... >> or you could validate the input with regEx... Accept zero or more digits.... (comp.lang.java.help)
Re: conditional validation formula ... You can't have data>validation that will validate for greater than 0 and ... allow for zero..... > portion of the formula ...Prev by Date: ... (microsoft.public.excel.worksheet.functions)
Re: Regular expression. ... or \d+ if you want 1 or more digits... > I need to validate the input of my text box. ...Prev by Date: ... (microsoft.public.dotnet.languages.csharp)
Re: Reg exp question ... > I'm trying to validate a number field that has to be exactly six digits... > cannot start with a zero:...Prev by Date: ... (microsoft.public.dotnet.languages.vb)
Custom Cell Format ... I am using XP OS and Excel 2002. ... custom format appears to be rounding all my last digits to zero....Prev by Date: ... (microsoft.public.excel.misc)