+ Reply to Thread
Results 1 to 6 of 6

Excel formula bar to display the result of the formula , not the formula?

  1. #1
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,566

    Excel formula bar to display the result of the formula , not the formula?

    Hello to all,
    is this possible?

    Excel formula bar to display the result of the formula, not the formula

    max_max

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,275

    Re: Excel formula bar to display the result of the formula , not the formula?

    No, it isn't.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Forum Contributor
    Join Date
    09-21-2016
    Location
    UK
    MS-Off Ver
    2016
    Posts
    131

    Re: Excel formula bar to display the result of the formula , not the formula?

    What about selecting a cell Right Click -> Format Cells -> Protection -> and tick Hide

  4. #4
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    7,747

    Re: Excel formula bar to display the result of the formula , not the formula?

    Hi All

    I do not see why that would be impossible.

    Use a Sheet Specific Selection Change macro

    use the macro to copy the formula in the cell into a string.

    copy paste the value into the cell.

    When another cell is selected or the sheet is changed or the workbook is closed

    then enter the formula back into the cell.

    That is the theory, I assume the practice will be harder.
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

  5. #5
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    7,747

    Re: Excel formula bar to display the result of the formula , not the formula?

    Unable to edit my original post.

    Please Login or Register  to view this content.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,275

    Re: Excel formula bar to display the result of the formula , not the formula?

    @ChipSlave - try it and see.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula result will only display as 0 (zero)
    By bulina2k in forum Excel General
    Replies: 5
    Last Post: 11-25-2016, 05:55 AM
  2. Replies: 9
    Last Post: 06-02-2016, 03:19 PM
  3. Replies: 7
    Last Post: 11-27-2015, 11:12 AM
  4. [SOLVED] how do i get excel to display the result of a formula i build?
    By Mike in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-25-2006, 03:30 AM
  5. display words in a formula result in Excel
    By dhollifield in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-17-2005, 11:45 PM
  6. [SOLVED] Can I make a formula in Excel to display result in same cell?
    By Neiko in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-01-2005, 06:05 PM
  7. [SOLVED] How do I display the RESULT of a formula
    By Poor microsoft user in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 04-27-2005, 11:06 AM

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