+ Reply to Thread
Results 1 to 3 of 3

Display formulas with numbers instead of cell reference

  1. #1
    Registered User
    Join Date
    06-01-2020
    Location
    Switzerland
    MS-Off Ver
    M365
    Posts
    2

    Display formulas with numbers instead of cell reference

    Dear community,

    I am struggling with something I believe is a very basic problem...

    I created an Excel sheet and need to copy several formulas to another program. However, I can only find a function which is called show formula. The problem is that I need the actual formula with numbers instead of cell references:

    =100/(20-5)^2 instead of =B3/(C8-D2)^D5

    Is there anyone that could help me with this problem?

    Many thanks in advance.

    Best

    Benjamin

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,416

    Re: Display formulas with numbers instead of cell reference

    Welcome to the forum.

    It may seem a basic problem, but the call for it is so minimal that there is no way to do it with formulae. It may be possible with VBA - shall I move the thread for you?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    06-01-2020
    Location
    Switzerland
    MS-Off Ver
    M365
    Posts
    2

    Re: Display formulas with numbers instead of cell reference

    Thank you Ali,

    Yes, I would appreciate that!

    Thanks,

    Benjamin

+ 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. Replies: 6
    Last Post: 01-23-2018, 04:49 AM
  2. [SOLVED] How to Display Numbers Only OR How To Extract Numbers In A Cell
    By PaddyP in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-17-2016, 12:32 PM
  3. Display value in formula instead of reference to cell
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-06-2014, 03:38 PM
  4. Highlight Cell if Reference is Blank but Display 0
    By uberathlete in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-04-2014, 11:50 AM
  5. Display data reference from another worksheet based on cell reference
    By Drew123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2011, 03:52 PM
  6. Replies: 6
    Last Post: 06-30-2009, 04:02 PM
  7. [SOLVED] Formula to display cell reference (ex.. B7)
    By Irv in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-09-2006, 05:45 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1