Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Macro help (2000)

    Hi
    This is my first time at running a macro. I wanted to find out how to change a number into a date format. I found the answer on your 32113 post. It said you can run this macro on the selected cells. How do I do that? Do I select the cells then right click or select the cells and go to tools macro but then what?
    Also I have another question, in the find what how can I make excel look in default to Values instead of formulas
    PS thanks for having Woody

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Macro help (2000)

    <post#=32113>post 32113</post#> doesn't seem to be relevant to your question. However, the idea probably is:
    - Select the cells you want to modify.
    - Select Tools | Macro | Macros...
    - Pick the macro you want to run.
    - Click Run

    Excel will always search in formulas by default. It will remember the most recent setting within a session, though.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Macro help (2000)

    Hi Buckshot!

    To run a macro, you need to choose TOOLS | MACRO | MACRO'S, or press ALT + F8
    Then select the Macro from the list and choose Run.

    (If the macro has a short cut key, you can simply press that combination on the keyboard.) To creat a shortcut, press ALT + F8 and select the macro from the list, and then click Options. Assign a key combination...ie, CTRL + SHIFT+ Z (or any other letter).

    The attached file has a macro to convert text dates into dates. Keep cell A1 selected and run the macro from the instructions above, or simply press CTRL+SHIFT+Z (the shortkey for this macro!)

    Cheers
    Regards,
    Rudi

Posting Permissions

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