State Search By Zip Code
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 4439 articles for 1.786 sec
That formula worked a bit better. When formatted with [>99999]00000-0000;00000 I now have the perfect solution! Thanks to all who replied! On Oct 31, 12:18 pm, "T. Valko" <biffinp...@comcast.net> wrote: > Just because I'm anal.... > > You might want to include a test that the entry is numeric otherwise it'll > accept any entry that meets the length conditions. > > =AND(ISNUMBER(B4     

Group: microsoft.public.excel.misc · Group Profile · Search for State Search By Zip Code in microsoft.public.excel.misc
Author: Daron
Date: Nov 5, 2007 08:56

I don't think you are being "anal" at all... you raise an excellent point. Daron's original control for this was an attempt to use a Whole Number validation (which, of course, didn't work when coupled with the attempted length controls). Once I switched Daron over to the "Custom" validation, it exposed his entries to non-digits. I'm just angry at myself for not recognizing this in my previous
Show full article (4.57Kb) · Show article thread
Just because I'm anal.... You might want to include a test that the entry is numeric otherwise it'll accept any entry that meets the length conditions. =AND(ISNUMBER(B4),OR(LEN(B4)=5,LEN(B4)=9)) -- Biff Microsoft Excel MVP "Daron" <Daron.Lowell@gmail.com> wrote in message news:1193842134.536950.190070@o80g2000hse.googlegroups.com... > Rick, > > That worked! Thanks for your help     

Group: microsoft.public.excel.misc · Group Profile · Search for State Search By Zip Code in microsoft.public.excel.misc
Author: Rick Rothstein (MVP - VB)
Date: Oct 31, 2007 10:31

Rick, That worked! Thanks for your help! -Daron On Oct 31, 9:27 am, "Rick Rothstein \(MVP - VB\)" <rickNOSPAMn...@NOSPAMcomcast.net> wrote: Try setting your Validation to "Custom", not Whole Number, for you data range... use your same formula though. Rick "Daron" <Daron.Low...@gmail.com> wrote in message news:1193834158.874613.264880@k79g2000hse.googlegroups.com
Show full article (4.93Kb) · Show article thread
Try setting your Validation to "Custom", not Whole Number, for you data range... use your same formula though. Rick "Daron" <Daron.Lowell@gmail.com> wrote in message news:1193834158.874613.264880@k79g2000hse.googlegroups.com... > Thanks everyone for your suggestions. It would appear that I need to > be a bit more specific. > > The current format for these cells is [>99999]00000-0000     

Group: microsoft.public.excel.misc · Group Profile · Search for State Search By Zip Code in microsoft.public.excel.misc
Author: T. Valko
Date: Oct 31, 2007 10:18

Thanks everyone for your suggestions. It would appear that I need to be a bit more specific. The current format for these cells is [>99999]00000-0000;00000 so that the users don't have to worry about the dash I'm not worried about leading 0's as all my users are in NY State in locations where the zip code should start with a 1. And, I had an error in my original formula. The correct formula
Show full article (4.22Kb) · Show article thread
complaints sent to: abuse@verizon.net spam@uce.gov Received: from ([206.46.252.115]) by ******** with ESMTP id KP-BPZAB.135477875; Fri, 10 Aug 2007 14:39:27 -0500 Received: from vms114.mailsrvcs.net ([192.168.1.2]) by vms115.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0JMK000YLP9L4A3G@vms115.mailsrvcs.net> for ***@********     

Group: microsoft.public.excel.misc · Group Profile · Search for State Search By Zip Code in microsoft.public.excel.misc
Author: Daron
Date: Oct 31, 2007 07:48

If you can't open the file after downloading, it, try moving it to the folder where you normally keep your data. Then right-click the file (in My Computer) and choose Properties. You may find there is a button there for allowing you to handle the security if the file (not Access security.) -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne
Show full article (3.69Kb) · Show article thread
I appreciate everyone's suggestion's. I tried a few on line downloads but when I try to open I seem to be getting some security issue and can't open. Coach , I will be away for a few days but I would appreciate your offer. I dont know how to arrange it. I will check back when I return. Thank you so much. Joe -- Thanks for any assistance "CoachBarkerOJPW" wrote: > If you     

Group: microsoft.public.excel.misc · Group Profile · Search for State Search By Zip Code in microsoft.public.excel.misc
Author: Rick Rothstein (MVP - VB)
Date: Oct 31, 2007 06:27

If you can not find them I have them and would be willing to send them to you. -- Thank you very much CoachBarkerOJPW "raskew via AccessMonster.com" wrote: Hi - Do a Google search on download zipcodes. You'll find a number of responses, some free, some for a fee. Bob NNlogistics wrote: I am not sure if this question is appropriate but.................
Show full article (3.43Kb) · Show article thread
    

Group: microsoft.public.excel.misc · Group Profile · Search for State Search By Zip Code in microsoft.public.excel.misc
Author: Daron
Date: Oct 31, 2007 05:35

Show full article (3.07Kb) · Show article thread
    

Group: news.admin.netabuse.sightings · Group Profile · Search for State Search By Zip Code in news.admin.netabuse.sightings
Author: No Junk E-mail
Date: Aug 10, 2007 16:30

Show full article (1.36Kb)
    

Group: microsoft.public.access · Group Profile · Search for State Search By Zip Code in microsoft.public.access
Author: Allen Browne
Date: Jul 15, 2007 06:09

Show full article (1.70Kb) · Show article thread
    

Group: microsoft.public.access · Group Profile · Search for State Search By Zip Code in microsoft.public.access
Author: NNlogistics
Date: Jul 15, 2007 05:30

Show full article (1.04Kb) · Show article thread
    

Group: microsoft.public.access · Group Profile · Search for State Search By Zip Code in microsoft.public.access
Author: CoachBarkerOJPW
Date: Jul 14, 2007 13:50

Show full article (0.61Kb) · Show article thread
1 · 2 · 3 · 4 · 5 · 6 · 7 · 8 · 9 · next