iamnu
Tue May 06 13:08:54 CDT 2008
On May 6, 11:46 am, "Rick Rothstein \(MVP - VB\)"
<rick.newsNO.S...@NO.SPAMverizon.net> wrote:
> Yeah, it doesn't work for me either.<g>
>
> The OP mentioned leading zeroes in his post, so what makes you think I would
> have tested for that particular condition.<bg>
>
> Rick
>
> "Dave Peterson" <peter...@verizonXSPAM.net> wrote in message
>
> news:48209273.61A0F735@verizonXSPAM.net...
>
> > That didn't work for me.
>
> > Excel stripped off the leading 0's before applying the validation rules.
> > And so
> > the =len(a1) portion failed.
>
> > "Rick Rothstein (MVP - VB)" wrote:
>
> >> Try this Custom Validation formula...
>
> >> =AND(LEN(A1)=4,ISNUMBER(A1))
>
> >> Rick
>
> >> "iamnu" <iamn...@gmail.com> wrote in message
> >>news:1f986b4c-5461-465b-802a-733f10b11d70@d77g2000hsb.googlegroups.com...
> >> > On May 6, 9:54 am, "Earl Kiosterud" <some...@nowhere.com> wrote:
> >> >> You don't say if 0001 and 1 are to be considered equivalent, so I'll
> >> >> give
> >> >> this a shot.
> >> >> Data - Validation - Whole number - Between 0 and 9999.
> >> >> --
> >> >> Regards from Virginia Beach,
>
> >> >> Earl Kiosterudwww.smokeylake.com
> >> >> -----------------------------------------------------------------------"iamnu"
> >> >> <iamn...@gmail.com> wrote in message
>
> >> >>news:376d1bd4-49d7-4ac6-8ed6-a464c6d24dd8@m44g2000hsc.googlegroups.com...
>
> >> >> >I want to use data validation on a cell where the user MUST enter any
> >> >> > four digits, leading zeros are permitted.
>
> >> >> > Can someone explain how I do this?
>
> >> > "The user MUST enter 4 digits." That means that 0001 and 1 are NOT
> >> > equivalent.
> >> > Thanks for trying to help, though. I appreciate any suggestions...
>
> > --
>
> > Dave Peterson
The new formula didn't work either, but I am not considering using
Dave's suggestion. Thanks all for the help.