+ Reply to Thread
Results 1 to 3 of 3

How to copy a column of numbers that are created from formulas as regular numbers?

  1. #1
    Registered User
    Join Date
    05-08-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2011
    Posts
    32

    Question How to copy a column of numbers that are created from formulas as regular numbers?

    I have a column of numbers that are created from a formula. I need to copy those numbers into another spreadsheet as whole numbers (not as a formula). Is it possible to do, if so how?

    Thanks

  2. #2
    Forum Contributor
    Join Date
    04-23-2013
    Location
    Abu Dhabi United Arab Emirates
    MS-Off Ver
    Excel 2010
    Posts
    178

    Re: How to copy a column of numbers that are created from formulas as regular numbers?

    select the range to copy and on the other sheet you paste as special, right click on any column then select phase special and tick values click ok

  3. #3
    Registered User
    Join Date
    05-08-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2011
    Posts
    32

    Re: How to copy a column of numbers that are created from formulas as regular numbers?

    Thats great! Thanks

+ 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