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 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.Originally Posted by khalid79m
---
Si fractum non sit, noli id reficere.
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.Originally Posted by khalid79m
can you paste one or two of the formula that gives a problem, and the contents of the reference cell
---
thanks managed to solve this thanks for your time and patience
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks