Results 1 to 2 of 2

Thread: I want a macro form Excel VBA for formatting cells in such a way that

  1. Nov 12th, 2004, 09:48 AM #1
    BiradarSantosh
    BiradarSantosh is offline

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

    I want a macro form Excel VBA for formatting cells in such a way that

    There are already values in the form of ZipCode, but those are not in the format of "#####-####", so i want macro to replace those format with standard format

    Thanku
    Reply With Quote Reply With Quote
  2. Nov 12th, 2004, 10:55 AM #2
    Ecniv
    Ecniv is offline
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343
    Start a macro record
    Highlight all the cells
    Right click>Format Cells (general tab)
    Select custom format
    Enter the format
    Click ok
    Stop the recording
    Look at the code...

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...
    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