Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Oct 2002
    Location
    Bluffton, South Carolina, USA
    Posts
    88
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula Description (Result) (2003)

    when selecting a formula from the excel tool bar and executing, I see the correct answer in the "Insert Function" dialog box. But, when I select enter, it doesn't show up in my spreadsheet. I've tried "CTRL+`" and Selecting the "Formula Auditing Mode" from the toolbar, but it doesn't help.

    How do I get the answers to show on my spreadsheet????

  2. #2
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Formula Description (Result) (2003)

    Are you certain that there are no macros involved in this situation?
    Regards
    Don

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula Description (Result) (2003)

    Could you be a little more explicite in your description of the problem? First, I don't have any formula in my Excel tool bar, so where did the formulas in your tool bar come from? Second, answers don't show up in the Insert Function dialog box, formulas do. Do you really mean that the correct function shows up in the dialog box? Third, what does show up in the cell when you press enter? If you select the cell again after pressing enter, what is displayed in the formula bar? Fourth, What happens if you click on OK rather than pressing Enter?
    Legare Coleman

  4. #4
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Formula Description (Result) (2003)

    Hi sboyd,

    Are you referring to formula insertion via the 'Paste Function' button on the 'Standard' toolbar? If so, the process is to:
    . select the destination cell
    . click on 'Paste Function' button
    . choose the required function
    . click OK (or press <Enter>)
    . input the relevant parameters
    . click 'OK' (or press <Enter>)again.
    The auditing toolbar has nothing to do with this.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

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