+ Reply to Thread
Results 1 to 3 of 3

How to insist to show results for all formulas?

  1. #1
    Registered User
    Join Date
    07-09-2009
    Location
    Kiev, Ukraine
    MS-Off Ver
    Excel 2007
    Posts
    4

    Question How to insist to show results for all formulas?

    Hi,

    I have a lot's of formulas on spreadsheat. Some of them simple like (=R[-101]C), others more complex like(="LOC_" & VALUE(MID(R[-101]C[-8],5,6)) + 101).
    Some of cells show result while others show formulas instead. When I press F9 while editing for formulas which doesn't display result it shows correct result - so, formulas are correct.
    Somehow I insisted for some columns to show results but could not reproduce it for others.

    How to insist to show results for all formulas?

    I use Excel 2007.

    Thanks,
    Sergiy
    Last edited by kiberpress; 07-13-2009 at 11:09 AM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: How to insist to show results for all formulas?

    If you "re-enter" formulae the cells will coerce from Text to General and results will be displayed... a few ways to do this:

    1 - highlight cells affected and run Edit -> Replace: What: = With: =
    2 - highlight cells affected one column at a time and run Text to Column -> click Finish
    3 - format cells to General - edit formulae individually and press return (ie F2 -> Enter)

    Option 1 likely to be your best bet...

  3. #3
    Registered User
    Join Date
    07-09-2009
    Location
    Kiev, Ukraine
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: How to insist to show results for all formulas?

    Hi,

    Item 1) is working perfect for me. Thank you very much for this.

    As far as I understand it flushes cells' format to some default format state while replace which cause formula calculation, am I correct?

    Thanks,
    Sergiy

+ 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