Welcome Guest
Log In | Register )
You last visited January 16, 2017, 7:47 pm
All times shown are
Eastern Time (GMT-5:00)

excel question on copy paste function

Topic closed. 2 replies. Last post 7 years ago by jester001.

Page 1 of 1
PrintE-mailLink
Avatar

Philippines
Member #67927
December 8, 2008
67 Posts
Offline
Posted: May 23, 2010, 2:16 am - IP Logged

hello everyone i just have a question regarding excels cut and paste function. for example i have formula in cell c1 like "=a1-2" and the number that shows in sheet is 5. i tried to copy it on another sheet but i seem to be copying the formula instead of the number that shows in the scree. is there a way for me to just copy the number not the formula in another sheet? tnx alot to anyone who will help. :)

    CARBOB's avatar - FL LOTTERY_LOGO.png
    ORLANDO, FLORIDA
    United States
    Member #4924
    June 3, 2004
    5960 Posts
    Online
    Posted: May 23, 2010, 5:25 am - IP Logged

    hello everyone i just have a question regarding excels cut and paste function. for example i have formula in cell c1 like "=a1-2" and the number that shows in sheet is 5. i tried to copy it on another sheet but i seem to be copying the formula instead of the number that shows in the scree. is there a way for me to just copy the number not the formula in another sheet? tnx alot to anyone who will help. :)

    Put cursor in C1, right click, copy place cursor in cell where you want the value, right click, paste special, values-number format, OK

      Avatar

      Philippines
      Member #67927
      December 8, 2008
      67 Posts
      Offline
      Posted: May 23, 2010, 7:22 am - IP Logged

      tns alot sir. :)