+ Reply to Thread
Results 1 to 5 of 5

how to change a calculated cell to = the calculated value

  1. #1
    CAM
    Guest

    how to change a calculated cell to = the calculated value

    I want to save a spreadsheet so that the values in the calculated cells are
    changed to equal the calculated values so that the hidden data/formulas used
    to calculate the values can then be removed. Any suggestions? Seemed like
    there was such a technique in Lotus 123 days but I've slept way too many
    times since then!

  2. #2
    Michael
    Guest

    RE: how to change a calculated cell to = the calculated value

    Hi CAM. If you just want the values and not the formulas select all the
    calculated cells, copy and then paste special - values before you save. HTH
    --
    Sincerely, Michael Colvin


    "CAM" wrote:

    > I want to save a spreadsheet so that the values in the calculated cells are
    > changed to equal the calculated values so that the hidden data/formulas used
    > to calculate the values can then be removed. Any suggestions? Seemed like
    > there was such a technique in Lotus 123 days but I've slept way too many
    > times since then!


  3. #3
    Bill Martin
    Guest

    Re: how to change a calculated cell to = the calculated value

    CAM wrote:
    > I want to save a spreadsheet so that the values in the calculated cells are
    > changed to equal the calculated values so that the hidden data/formulas used
    > to calculate the values can then be removed. Any suggestions? Seemed like
    > there was such a technique in Lotus 123 days but I've slept way too many
    > times since then!


    -------------------------------

    If I understand you correctly, what you need to do is simply mark the cells you
    want to change, copy them and then use PasteSpecial>ValuesOnly to paste the same
    data back into the same cells. At that point the cells will contain numbers
    rather than formulas.

    Bill

  4. #4
    CAM
    Guest

    Re: how to change a calculated cell to = the calculated value

    Awesome guys. That trick coupled with the Remove Hidden Data tool make it
    really easy to cleanup and distribute worksheets.
    Thanks again Michael & Bill

    "Bill Martin" wrote:

    > CAM wrote:
    > > I want to save a spreadsheet so that the values in the calculated cells are
    > > changed to equal the calculated values so that the hidden data/formulas used
    > > to calculate the values can then be removed. Any suggestions? Seemed like
    > > there was such a technique in Lotus 123 days but I've slept way too many
    > > times since then!

    >
    > -------------------------------
    >
    > If I understand you correctly, what you need to do is simply mark the cells you
    > want to change, copy them and then use PasteSpecial>ValuesOnly to paste the same
    > data back into the same cells. At that point the cells will contain numbers
    > rather than formulas.
    >
    > Bill
    >


  5. #5
    Michael
    Guest

    Re: how to change a calculated cell to = the calculated value

    Your welcome, CAM. Thanks for the feedback.
    --
    Sincerely, Michael Colvin


    "CAM" wrote:

    > Awesome guys. That trick coupled with the Remove Hidden Data tool make it
    > really easy to cleanup and distribute worksheets.
    > Thanks again Michael & Bill
    >
    > "Bill Martin" wrote:
    >
    > > CAM wrote:
    > > > I want to save a spreadsheet so that the values in the calculated cells are
    > > > changed to equal the calculated values so that the hidden data/formulas used
    > > > to calculate the values can then be removed. Any suggestions? Seemed like
    > > > there was such a technique in Lotus 123 days but I've slept way too many
    > > > times since then!

    > >
    > > -------------------------------
    > >
    > > If I understand you correctly, what you need to do is simply mark the cells you
    > > want to change, copy them and then use PasteSpecial>ValuesOnly to paste the same
    > > data back into the same cells. At that point the cells will contain numbers
    > > rather than formulas.
    > >
    > > Bill
    > >


+ 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