Results 1 to 3 of 3

Thread: I want macro in Excel to format cells as Zipcode in the format #####-####

  1. Nov 12th, 2004, 08:10 AM #1
    BiradarSantosh
    BiradarSantosh is offline

    Thread Starter
    New Member
    Join Date
    Nov 2004
    Location
    India
    Posts
    2

    Post I want macro in Excel to format cells as Zipcode in the format #####-####

    Hello
    Reply With Quote Reply With Quote
  2. Nov 12th, 2004, 09:19 AM #2
    BrianB
    BrianB is offline
    Addicted Member
    Join Date
    Aug 2002
    Location
    Luton, UK
    Posts
    178
    You could have got this yourself by recording a macro :-


    Code:
    ActiveSheet.Range("A1").NumberFormat = "#####-#####"
    Regards
    BrianB
    -------------------------------
    Reply With Quote Reply With Quote
  3. Mar 1st, 2005, 05:21 PM #3
    wherewasi
    wherewasi is offline
    Member
    Join Date
    Jul 2001
    Location
    Way, way out there...
    Posts
    53

    Re: I want macro in Excel to format cells as Zipcode in the format #####-####

    Thanks Brian... I used your post also...

    Tom
    Tom

    This is why I'm forcing my son to become a vet...

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width