+ Reply to Thread
Results 1 to 3 of 3

Formula 'No Show' - Why Result Only

  1. #1
    Registered User
    Join Date
    02-10-2005
    Location
    Twangtown USA
    Posts
    6

    Formula 'No Show' - Why Result Only

    In Excel 97:

    The formula isn't showing in the formula bar / line when I pick the cell that is supposed to contain a FORMULA! Only the result of the formula shows. I cannot copy/paste the formula to other cells because Excel thinks it (the formula) is not there.

    Is this a formatting issue - OR - is there a setting to 'show the formula' - INSTEAD -of just the result?

    Signed,
    Inexperienced

  2. #2
    Registered User
    Join Date
    03-29-2004
    Posts
    5
    My assumption is that the formulae has been copied over. It could also be that the sheet is protected with the cells protection format set to hidden.

  3. #3
    Registered User
    Join Date
    02-10-2005
    Location
    Twangtown USA
    Posts
    6

    Thumbs up Affirmative

    Thanks muchly... that was indeed the case.
    - Problem solved!
    Clint H.
    Man taming the beast - MS Excel 97 !

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1