+ Reply to Thread
Results 1 to 5 of 5

copy and paste help required

  1. #1
    Forum Contributor
    Join Date
    12-16-2006
    Posts
    349

    Wink copy and paste help required

    When I copy and paste from one sheet to another workbook , the formulas stay intact but display 0 as the result ? when could this be happening ?

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,196
    Quote Originally Posted by khalid79m
    When I copy and paste from one sheet to another workbook , the formulas stay intact but display 0 as the result ? when could this be happening ?
    when the sheet you copy to has 'zero values' ticked in Tools, Options.

    ---
    Si fractum non sit, noli id reficere.

  3. #3
    Forum Contributor
    Join Date
    12-16-2006
    Posts
    349

    hi thanks , but still doesnt work

    The values should not be zero's the formulas are correct but display when pasted ... any suggestions

  4. #4
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,196
    Quote Originally Posted by khalid79m
    The values should not be zero's the formulas are correct but display when pasted ... any suggestions
    without seeing one of the formula it would be difficult to guess.

    can you paste one or two of the formula that gives a problem, and the contents of the reference cell

    ---

  5. #5
    Forum Contributor
    Join Date
    12-16-2006
    Posts
    349

    hi

    thanks managed to solve this thanks for your time and patience

+ 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