Results 1 to 3 of 3

Thread: Unable to transform formulas excel cells in values

  1. #1
    Join Date
    Oct 2011
    Posts
    2

    Unable to transform formulas excel cells in values

    in use Linest formula (multiple variables regression) in excel 2007 I try to transform the formula display into the result (value) of the formula by clicking ctrl + ~ but the formula continue to be dispalying
    Do toy how to do it?

  2. #2
    Join Date
    Dec 2007
    Posts
    2,291

    Re: Unable to transform formulas excel cells in values

    If you copy the cell in question, then click Edit, Paste Special and choose the Values option you should get what you want.

  3. #3
    Join Date
    Oct 2011
    Posts
    2

    Re: Unable to transform formulas excel cells in values

    Quote Originally Posted by einstein_007 View Post
    If you copy the cell in question, then click Edit, Paste Special and choose the Values option you should get what you want.
    Thanks Einstein_007

Similar Threads

  1. Is it possible to have Excel formatting and formulas in CSV
    By TheCarter in forum MS Office Support
    Replies: 2
    Last Post: 02-02-2012, 04:44 PM
  2. Hiding Values and locking cells excel2007
    By Evoldo in forum Windows Software
    Replies: 3
    Last Post: 28-03-2011, 03:32 AM
  3. How formulas are calculated in Excel?
    By The Recruiter in forum Windows Software
    Replies: 5
    Last Post: 26-03-2010, 03:39 AM
  4. How can i hide formulas in MS Excel
    By Orton in forum Windows Software
    Replies: 3
    Last Post: 04-07-2009, 08:45 PM
  5. Problem to combine the values of cells in the order
    By windows_user in forum Software Development
    Replies: 4
    Last Post: 16-04-2009, 11:35 PM

Tags for this Thread

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
  •  
Page generated in 1,713,442,374.09739 seconds with 17 queries